[Phpgroupware-developers] XML & Schema Proc

[Michael Dean]

Hey all!

In talking to skwashd about doing some schema proc work, I brought up
the fact that I have an XML definition for defining the database schema
that is used by DCL HEAD and GNU Enterprise.  What I'd like is to get a
feel for the level of interest in moving schema proc to run completely
from XML.

I currently have style sheets that perform the following:

* Create MSSQL XML command script
* Create MySQL XML command script
* Create PostgreSQL XML command script
* Create Sybase XML command script
* Transform a command script into a SQL script
* Transform the original definition into a DHTML schema browser

The XML command script mentioned above is just a series of SQL
statements that can be ran.

What this definition lacks is defining default data and upgrades.  It
should also be noted that a transform could be created to generate PHP
if one was so inclined.

I feel with the move to XML/XSLT in phpGW that this is a very logical
step to take.  It also makes supporting new RDBMS' a cake on the schema
side because you just write a new transform to translate data types and
such for that particular RDBMS.

I plan on throwing this into the wiki (with more detail) if y'all would
like to make a go of it.

Mike