headers
Lukas Kahwe Smith | 10 Mar 08:22

Re: [phpdba] Database Schema XML

Thomas Koch wrote:

> well, the nice thing with standards is, that there are so many to choose 
> from...
> That was exactly my problem: I searched ONE canonical format to save such a 
> basic thing like a database schema, so that it could be read and written by 
> many programs.

Well the Metabase format is supported by Metabase, MDB, MDB2_Schema,
ezc::DatabaseSchema as well as the DBDesigner ER Tool. I am not aware of
anything equally supported .. at least in the PHP scene.

You can also validate against a DTD or XSD .. plus there is a nice XSLT
to view the schemas:
http://cvs.php.net/viewvc.cgi/pear/MDB2_Schema/docs/

regards,
Lukas
Permalink | Reply |
headers
Lukas Kahwe Smith | 10 Mar 08:34

Re: [phpdba] Database Schema XML

Lukas Kahwe Smith wrote:

> You can also validate against a DTD or XSD .. plus there is a nice XSLT
> to view the schemas:
> http://cvs.php.net/viewvc.cgi/pear/MDB2_Schema/docs/

There are still a few things missing in this format. For one foreign 
keys, although there are already a few proposals out there for adding 
this. One is shown here:
http://oss.backendmedia.com/MDB2/ForeignKeys

Other things missing are VIEWs, though Igor's work during the SoC 2006, 
atleast gave us WHERE statement support. Triggers and CHECK constraints 
are also missing. Setting Charsets as well as proper generic support for 
RDBMS specific optimizations would be nice (so you could for example 
define that a VIEW is a materialized view on oracle). The list of nice 
to haves goes on.

regards,
Lukas
Permalink | Reply |

Gmane