As a single developer on a single application running different environmentsспални комплекти I find it tedious to have to duplicate my database changes everytime, whether they are permanent or not. When working with a group of developers and all of use making changes to the database schema it becomes even more hectic as to what was changed.

Since I am writing PHPDbMigrate as a PHP database migration manager and since ateI’m working with CodeIgniter almost exslusively I decided to incorporate PHPDbMigrate as a way for me to manage the applications database schema into CodeIgniter.

Now as I make the needed schema changes I only have to do it in a migration file. From which I can easily update all my environment databases. Along with that the other developers can easily see what I have changes, and I can likewise see their changes. Additionally PHPDbMigrate supports code blocks for running native PHP code in the migration for added help!

In the event we need to roll back those changes we have the option to do so to specific versions. This is an extremely important aspect to a failed production deploy where the code needs to be reverted as well as the database.

Installation is fairly straight forward. Choose the tar or the zip type downloads below and extract into your application. I have a README in the root folder to explain the rest on the install.

Currently PHPDbMigrate only supports Mysql(i). I’m bringing on more database types soon.

PHPDbMigrate-CodeIgniter zip file

PHPDbMigrate-CodeIgniter tar file

Tags: CodeIgniter, database, migrate

This morning I’ve finally released PHPDbMigrate RC 2.

The changes to this utility include:
all migration functions work in MySQL
mysql and mysqli database adapters supported

You can find the code here: http://code.google.com/p/phpdbmigrate/

I’ve still got work to do in support other database types and updating the wiki.

Tags: active migration, activemigration, database, php