Re: Package proposal: XML_Query2XML
| From: | Jesus M. Castagnetto | Date: | Mon, 27 Feb 2006 17:42:06 +0000 |
| Subject: | Re: Package proposal: XML_Query2XML | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-41516@lists.php.net to get a copy of this message | ||
Hi Lukas
--- Lukas Feiler <lukas@empoweredmail.com> wrote:
> Hi list!
>
> I developed (and documented very well) a package that might qualify as a
> PEAR package.
>
> Query2XML: http://query2xml.sourceforge.net
>
> Query2XML allows you to transform the records retrieved with one or more SQL
> SELECT queries into XML data. Very simple to highly complex transformations
> are supported. It was written with performance in mind and can handle large
> amounts of data. No XSLT needed.
Having dealt before with standarized output for a distributed system, I am
wondering if your package follows the SQL/XML mapping standard (see the info at
http://www.sqlx.org/)
FYI, there are ISO and ANSI standards on the mapping of data and identifiers
between SQL and XML. For the usual cases is rather trivial, the problem begins
with the maping of identifier names (tables, dbs, schemas, etc.), which in SQL
can be composed of anything, including spaces and other random stuff.
There is a more recent (2004) draft for the new SQL/XML standard that you could
peruse, or if you can, get the ISO and ANSI ones (from 2003) and use them as
good bedtime reading (I did back when they first came out :-)
> I wrote Query2XML because XML_sql2xml was just not flexible enough for my
> needs. Query2XML also uses PHP5's new DOM XML classes.
>
> Please let me know what you think,
> Lukas Feiler
Cheers.
--
Jesus M. Castagnetto (jcastagnetto@yahoo.com)
Web site: http://www.castagnetto.org/
Research: http://metallo.scripps.edu/
PEAR stuff: http://pear.php.net/user/jmcastagnetto
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com