Entry

Is there a PHP database schema generator available?

Jun 23rd, 2000 01:42
Manuel Lemos, Nathan Wallace, David Robley, Jean-Marc Libs

There are two MySQL administration tools which help you look after and
alter your database schema.  They are not really a graphic schema
generator however.

http://www.htmlwizard.net/phpMyAdmin/

http://modems.rosenet.net/FaceMySQL/


Metabase is a PHP database abstraction package that comes with a parser
class that lets you describe database independent schemas in a custom XML
format.  There is also a manager class that takes the parsed schema
description and executes the necessary database statements to install that
schema.

If you change the your database schema file, you may tell the manager class
to compare the installed schema with the new schema and execute the
necessary statments to apply the requested changes.  The alterations are
applied without affecting the data already stored in the database since was
installed or was the last time the schema was updated.

Metabase is freely available here:

http://phpclasses.UpperDesign.com/browse.html/package/20