While considering how I’m going to manage the new version of Blogwise, I decided it would be a good idea to keep revisions of details recorded, since automated processes will be updating blogs’ details fairly regularly and I want to note changes and be able to revert.
I use MySQL and I can’t find a good existing solution. This article suggests an ideal way one might go about it, and I was planning to adopt a similar idea anyway (storing diffs in some kind of history table) so seeing this has given me more confidence to try it!