zend_db

Update, 2012-05-24: Fixed some typos and added the screenshot (eyecandy!). I think it took me (or us) a couple attempts to get this right — let me introduce you to Zf_Crud, a CRUD controller for the Zend Framework. What’s CRUD? CRUD is an acronym and stands for: Create Read Update Delete A general purpose for CRUD are administrative interfaces — view records, create them, update them or delete them. Think of phpMyAdmin as a very general purpose CRUD interface....

So frequently, I need to run small data migrations or transformations. Especially on the way to Doctrine, there’s a lot to clean-up in a database which has been used and evolved over five years or so. The other day, I wanted to run some transformations on the data located a history column in a pretty simple table — here’s what it looks like: Building a class to interface the table is simple:...