News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Lorna Mitchell's Blog:
Simple Database Patching Strategy
March 01, 2010 @ 14:10:53

In a new post to her blog today Lorna Mitchell has a few suggestions for handling database patching when your application starts to outgrow its simple roots.

One problem that seems to need solving too often is how to keep databases in sync across different platforms, different developers working on a project, and deploying database changes along with code changes. There are lots of ways of approaching this, none of them are really excellent however and personally I tend to err on the side of simple being better. Fewer dependencies means a solution more likely to work on every platform (and no additional complications for the live platform). Usually this means patch files of some kind.

She outlines her usual approach - creating a table with metadata and version information, export the structure of the database in push it into a row, creating numbered patch files and keeping it all stashed away in versioned source control for easy access. Check out the comments for some more interesting ideas.

1 comment voice your opinion now!
database patch strategy tutorial


blog comments powered by Disqus

Similar Posts

WebRefernece: Script GUI for PHP

ZendCasts.com: Autocomplete Control with ZendX_JQuery

Fawad Hassan's Blog: Load More Using KnockoutJS, PHP/CodeIgniter (Part 1)

DevShed: Decoupling the Validation of Data with Bridge Classes in PHP 5

Kevin Schroeder's Blog: Connecting to the Zend Developer Cloud using NetBeans for PHP


Community Events











Don't see your event here?
Let us know!


hack threedevsandamaybe opinion facebook framework introduction symfony2 install component release unittest code package application podcast composer hhvm language security overview

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework