[Catalyst] How safe are database transactions?

[Perrin Harkins]

Yuval Kogman wrote:
> However, you still have to be aware of the ACID semantics of your
> DB, because they may be on crack.
> 
> IIRC postgresql is actually one of the good guys in terms of this.
> MySQL before version 5 (or was it 4.1?) was naughty.

I think you're referring to isolation levels here.  The default MySQL 
InnoDB isolation level was stricter than Postgres or Oracle, which 
caused a lot of headaches.  Anyone using MySQL InnoDB should check their 
isolation level.  See 
http://perl.apache.org/docs/1.0/guide/databases.html#Transactions_Not_Committed_with_MySQL_InnoDB_Tables

- Perrin