RE: [PEAR-DEV] Re: xsd2db

> -----Original Message----- > From: Manuel Lemos [mailto:mlemos@acm.org] > Sent: Thursday, February 27, 2003 4:52 PM > To: pear-dev@lists.php.net > Subject: [PEAR-DEV] Re: xsd2db > > Hello, > > On 02/27/2003 09:52 AM, Sandro Zic wrote: > > I did a proof of concept converting a XML schema definition to MySQL > CREATE > > TABLE statements with XSLT. > > http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/zzoss/zzoss/utils/xsd2db/ > > > > Of course, the current implementation does not handle all aspects of > MySQL > > table definitions. > > > > The purpose is to have several xsd2db stylesheets for various RDBMS, and > LDAP. > > This would need some extra schema being introduced like for DB2: > > > http://www7b.software.ibm.com/dmdd/library/techarticle/0209lima/0209lima .h > tml > > Also, how to best handle nested elements of a XSD in a RDBMS is yet an > open > > question to me. > > > > I sent this to pear-dev, because maybe this is of interest to PEAR::MDB? > > Basically you seem to want to replicate a functionality that > Metabase/MDB already provide and works well. What would be the advantage > of using XSLT for the same purpose? > > > > Does anyone know of similar XSLT stylesheets serving the same purpose? > > Personally, I only see disadvantages in resorting to XSLT to generate > SQL scripts to install and update database schemas, especially when > there is already a working and tested PHP solution for that purpose. > Maybe I am missing something here. Well the advantage is that this seems to enable people to use the xml schema without having to use Metabase/MDB. So this could help the adoption of the xml format itself. Maybe I am missing something here :-) Regards, Lukas