Tag: database version control

Database patching is a wicked hard problem, one that's got a bit easier in my world lately as I've been using Phinx on a few projects. I like Phinx because it avoids the numbered-patches problem by using date stamps as part of its patch naming and it is pretty smart about creating the correct forward and backward changesets from a single change() description.

One thing I didn't immediately find was how to insert data.

I wrote recently about deployment and I got some followup questions about managing database changes when you've got multiple versions of code hanging around.

There are two things you need to come to terms with:

• There is no silver bullet

• Rigid process is required