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
So it’s been a couple of months since I posted last. I’ve really been heads down on coding at both work and home. Things are starting to lighten up in both areas and I’m ready to start a new project, PHPDbMigrate.
At work I’ve been setting up a lot of sites using CodeIgniter. It’s not a bad framework and since I’ve been away from PHP for a while it’s nice to be coding in PHP again. Not much really exciting going on at work, just setting up websites and modifications to existing code.
At home though is entirely different. For thre months now I’ve been developing Value Target. Launched it June 7. It’s definately a labor of love and still have lot’s to do on it. It’s a rails app and I’ve really fallen in love with the framework. So much so that I am going to port PyMigrate to PHP.
PHPDbMigrate is the name of the port. Yes there are “some” attempts out there to create an ActiveMigration library. I find that they are limited to MySql, not complete, or do not run code blocks. Since I’ve already accomplished that in Python, it’ll be easy for me to port to PHP. Although I won’t have the luxury of db connector library like I did with SQLAlchemy in Python.
I’ve set up the Google code project and will announce all my updates to the repository.
After I finally release a stable version of PHPDbMigrate my plan is to create a CodeIgniter library so I can develop sites even faster. So thanks for checking in and stay tunes.
Tags: php, PHPDbMigrate, Value Target
Subscribe
Entries