I am proud to announce the immediate availability of Cake DB Migrations V2.0.

This new version has been rewritten with portability in mind and now supports a list of database engines as long as your arm. The new features and changes are as follows:

  • Now supports mutiple database engines with the help of Pear’s MDB2
  • Simplified YAML migration files
  • Fully supports adding/dropping and altering fields
  • Supports the following field types: text, integer, blob, boolean, float, date, time, timestamp(datetime)
  • Ability to create primary key and unique indexes on new and existing fields
  • Script moved to the main Cake Vendors directory, so no need to touch your Cake core
  • Supports multiple Cake applications in the same way as Bake.php does
  • Works out of the box

What is Cake DB Migrations

Cake DB Migrations is a port of the very useful Ruby on Rails Migrations functionaility. Cake Migrations allow you to use Cake to define changes to your database schema, making it possible to use a version control system to keep things synchronised with the actual code.

This has many uses, including:

  • Teams of developers