* * * * *

       Not the source code to the database, the data in the database …

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?

Update on Friday, June 27^th, 2008

JeffC [3] weighs in with some suggestions [4].


[1] gopher://gopher.conman.org/0Phlog:2007/02/02.1
[2] gopher://gopher.conman.org/0Phlog:2006/10/10.1
[3] http://spinthecat.blogspot.com/
[4] http://spinthecat.blogspot.com/2008/06/versioning-data-in-database.html

Email author at [email protected]