News from Oct 08, 2007

The initial public release of the LiquiBase plugin for Grails is now available. LiquiBase is a database change management tool similar to Rail's ActiveRecord:Migrate.

Major functionality includes:

34 Refactorings
Extensibility to create custom refactorings
Update database to current version
Rollback last X changes to database
Rollback database changes to particular date/time
Rollback database to "tag"
Stand-alone IDE and Eclipse plug-in
"Contexts" for including/excluding change sets to execute
Ability to create changelog to generate an existing database
Database change documentation generation
Ability to save SQL to be applied for approval by a DBA
DBMS Check, user check, and SQL check preconditions
Can split change log into multiple files for easier management
Support for 11 database systems

The initial release requires changes to be managed in an XML format, although support for an easier to use domain specific language is planned for a future release.

Full documentation on the plugin is available at http://www.liquibase.org/manual/latest/grails.html