I received a call from R today. It had been awhile since I last worked with him [1] (we parted ways due to market change [2]) but he knew I could help him out in a pinch.
He's taken over the maintenance of a sizable website and needed some help in setting up a development server. No big deal (well, except for the control panels but I was able to at least point him in the right direction), and I even set up a revision control system when he threw me a curve ball—a significant portion of the site lives in a database, so is there any way to do revision control of stuff in the database?
And that's … something I've never thought of before. How do you do version control of data in a database?
JeffC [3] weighs in with some suggestions [4].
[3] http://spinthecat.blogspot.com/
[4] http://spinthecat.blogspot.com/2008/06/versioning-data-in-database.html