cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <dho...@csir.co.za>
Subject RE: XML for describing databases?
Date Fri, 15 Mar 2002 08:03:55 GMT
Please keep us all informed... this is also a topic I have been 
thinking about (in the background) for a while now.

A solid set of protocols and tools (read 'standard' XSLT and/or 
logicsheets?) for creating and generating reports/forms for
 databases/tables would be really cool and crank Cocoon's 
usability and desirability up a notch.  

I realize this is not really a Cocoon issue per se, but one 
that would make a very useful addition to the 'getting it
started out of the box' side of the system.

Derek

>>> mmcclelland@eduprise.com 14/03/2002 09:55:49 >>>
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>


---------------------------------------------------------------------
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