Icon: News & Updates News & Updates
» Simple slide show for prototype & scriptaculous
A little slide show object for any of you that use prototype and scriptaculous.
Staff Blogs Downloads
» Some things to listen to...
Some podcast recommendations - in case there weren't enough on the web already!
Staff Blogs
» PHP Optimization
PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'apd.so'
Staff Blogs
» Windows Explorer New Folder shortcut and button
If you've ever wished MS Windows Explorer had a shortcut for Create New Folder then look no further. I have found the perfect solution.
Staff Blogs Downloads
Icon: Creative Portfolio Creative Portfolio
Imation
Icon: Clients & Partners Clients & Partners
TMA Design & Marketing

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...