adodb-xmlschema

Originally written by Richard Tango-Lowy with many fine additions and improvements by Dan Cech.

For more information or to report bugs or enhancements, or to download the latest version, visit the adodb-xmlschema Sourceforge Project Page.

Introduction

adodb-xmlschema is a class that allows the user to quickly and easily build or upgrade a database on almost any RDBMS using the excellent ADODB database library and a simple XML formatted schema file.

This library is dual-licensed under a BSD-style license and under the GNU Lesser Public License. See the LICENSE file for more information.

Features

• Darned easy to install (included with all newer versions of ADODB).
• Create, upgrade and remove schemas on any platform supported by ADODB.
• Extract a schema from an existing database.
• Embed RDBMS-specific sections in a schema.
• Embed arbitrary SQL in a schema.
• Embed data in a schema.

Installation

To install adodb-xmlschema, simply copy the adodb-xmlschema.inc.php file and the xsl directory into your ADODB directory.

Documentation

See the docs directory for online documentation and tutorials.

News

Version 1.0.2

• Table prefixing is now working correctly.
• Support for uninstalling databases with the RemoveSchema command.
• You can now embed default data within the schema for population of tables.
• Many other fixes

Version 1.0.1

• The PHP XSLT module is now optional, and is only required for DTD conversions.
• It's now possible to execute the SQL inline (during parsing).
• Added a Using AXMLS tutorial (browse to index.html in the docs directory).

Version 1.0

• Thanks to Dan, AXMLS now uses XSLT to convert between DTD schema versions. XSLT will also allow us to create other transformations against the schema format in the future.
• Indexes are now part of the table object; they should no longer be declared seperately in the schema XML.
• Upgrading is now transparent. If you apply a schema to an existing table, the table gets upgraded to the new schema. This has been tested on Oracle and MySQL, but doesn't yet work on PostgreSQL (Very soon, very soon).
• In addition to parsing files, adoSchema now has methods for parsing XML Schema strings. This should give us more room to extend the library, and give you, the developer, room to manipulate the schema string should you feel the need.
• Check out the new Getting Started tutorial (browse to index.html in the docs directory) and improved autodocs. An Advanced User's Guide is in the works.

Thanks

Thanks to John Lim for giving us ADODB, and for the hard work that keeps it on top of things. And particulary for the datadict code that made xmlschema possible.

$Id: package_axmls.html,v 1.10 2004/07/28 17:18:32 dcech Exp $