Changelog functionality for databases

by NullQuery
Record changes to your SQL databases and manage upgrades
ID:2072236
 
Fork me on GitHub
This library allows you to record changes to an SQL database in an XML file. The purpose of this is to initialize an empty database with all the tables and sample data that you may need for your project.

Note that this library is not designed to function on its own, but needs one or more database abstraction libraries from the sql4dm suite.

Both Windows and Linux are supported. Tested on Windows 10 Professional and CentOS 7 (64-bit multiarch)

Bug reports and suggestions may be reported to the appropriate forum.

The library is object-oriented and is very simple to use. See the demo code in the project.

See the "sample_changelog.xml" for an example file. Best practice is to create a separate XML file per version of your BYOND project.

Also included is "changelog.xsd" which contains the XML markup rules for the changelog files.

Changelog:
Version 1.1
  • You can now specify a 'dbtype' attribute to 'sql' elements to only execute SQL for specific databases.
Version 1.0
  • Initial release.