Tuesday, January 16, 2007

sqlobject versions

It looks like SQLObject has versioning now.

"So, a version is a special attribute that catches updates and stores older values in a special additional table."

This is a very useful thing that I've been using on some projects myself. With it you can more easily recover from errors, and it also can allow your users to search through changes.

If SQL had versioning built in, it'd be much nicer. Temporal SQL is the name for this. However I think Oracle is the only major database to support it. No free ones do. So storing it in another table is an ok compromise.

I'm looking forward to the next SQLObject release - with versioning support, and other goodies.





Melbourne Web Developer Written by a Melbourne web developer. Available for your projects - php, mysql, e commerce, javascript, CMS, css, flash, actionscript, python, games, postgresql, xml.

1 comment:

philhassey said...

Sort of unrelated, but I set up versioning with user and date stamps for all changes to an sqlite database with sqlite triggers. Works pretty seamlessly.