Want a quick, lazy, command line way to pipe iso-8859-1 ( or any character encoding ) SQL into MySQL as UTF-8? Here's a little four-liner for you!
» SQL Rollback
» I thought I should provide an example of our little MyISAM transaction / rollback engine.. so here it is....
DeepBlueSky
9 Green Park Station
Bath
Bath and NE Somerset
BA1 1JB
England, UK
+44(0)1225 444674
hello@deepbluesky.com
Primary Navigation
News & Updates
iStylista - the new on-line personal shopping service is set to launch next month and boy are we excited!
A little slide show object for any of you that use prototype and scriptaculous.
Our online hotel, tour and travel portal - Gate54 - is back.
Creative Portfolio
- » News & Articles
- » Company News
- » Downloads
- » Event Advisories
- » Press Releases
- » Site Launches
- » Spirit News
- » Staff Blogs
- - - - - - -
- » June 2009
- » May 2009
- » April 2009
- » March 2009
- » February 2009
- » January 2009
Clients & Partners
.
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...
Care to comment?
Powered by Spirit Framework