I developed something similar for use with an application. I got it to do what I needed - but I also worked with my approach enough to uncover some pitfalls - so please let me know if you discover an xml schema to represent a database schema.
I did find some solutions that were built on the assumption of the database schema using the same structure as the xml schema like http://www.w3.org/XML/RDB.html Here are other useful links: http://www.rpbourret.com/xml/XMLDBLinks.htm http://www.rpbourret.com/xml/XMLAndDatabases.htm marty > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 1:49 PM > To: [EMAIL PROTECTED] > Subject: XML for describing databases? > > > Hey folks, > > I need to build a web interface to a whole bunch of > databases. To limit the work I'll have to do, I would like > to be able to define each database in a XML file, and have > the interface somewhat dynamically generated from those files. > > So, for one database named 'gesupply', part of the file > gesupply.xml would look like: > > ------------------------------------------- > <database> > <dsn>postgresql://localhost/gesupply</dsn> > <table name="contact"> > <row name="id"> > <parameter name="datatype" value="int4"/> > <parameter name="visible" value="false"/> > </row> > <row name="name"> > <parameter name="datatype" value="text"/> > <parameter name="visible" value="true"/> > </row> > > ... etc ... > > </database> > ------------------------------------------- > > The idea is, the xslt will generate the appropriate file(s) > to provide a basic interface to the database..... > > My question is: anyone know if a schema/xml-application like > this already > exists? Any searches for database+xml come up with dbxml or > something related whcih, unless I'm misunderstanding > something, isnt of use in this sort of application. > > -Tom > > --------------------------------------------------------------------- > Please check that your question has not already been answered > in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
