cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marty McClelland" <mmcclell...@eduprise.com>
Subject RE: XML for describing databases?
Date Thu, 14 Mar 2002 19:55:49 GMT
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: tvon@etria.org [mailto:tvon@etria.org] 
> Sent: Thursday, March 14, 2002 1:49 PM
> To: cocoon-users@xml.apache.org
> 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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message