Icon: News & Updates News & Updates
» Spirit 5.3 Released
Fast just got faster! We are very proud to announce the release of Spirit 5.3.
Company News
» A Solid Foundation
Welcome to our new range of small business web site packages.
Company News
Icon: Clients & Partners Clients & Partners
Imation

News & Articles

SQL Rollback

I thought I should provide an example of our little MyISAM transaction / rollback engine.. so here it is.

I've had a couple of queries about our pseudo 'transaction' system...   probably better referred to as "SQL Rollback" since it could quite easily be ported to any database engine, ACID or otherwise.

Anyway - I though a little demo of what it can do would be helpful.

This demo runs through a sequence of (currently) 9 statements and then rolls the whole lot back.  Each statement is executed as the page request runs.

At each stage a little method dumps the data from the tables out for you to see, highlighting any changes since the last time it ran.  Each statement itself is also dumped out so you can see what's going on.

So here it is: live demo of (software) SQL Rollback...