Re: [Phpgroupware-developers] XML & Schema Proc

[ceb]

hey mdean,
good to see you're back :)
i'm very interested in moving schema_proc to xml, makes most sense to me.
grtx. ceb


> > Michael Dean (address@hidden) wrote:
> > >
> > >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
> > >