@Chris
Man, you're spot-on with the very things that made me go back to PostgreSQL after the MySQL craze faded on me. I hated how the MyISAM backend was still being pushed, and the 3.x documentation insisted on telling us referential integrity and transactions were useless.
The funny thing is that the guy who actually pushed on this agenda of "no transactions" is the same guy who seems to be resigning. Maybe he's doing the whole MySQL team a favor?? I mean, the only other modern RDBMS that doesn't support transactions is MS Access, and you'd expect something like MySQL to be better than that! (And Access *does* have referential integrity!)
Even with the InnoDB engine, there are some quirks with MySQL that simply keep me off the thing. The day MyISAM tables turn into transactional, FK-supporting tables is the day that I *might* turn back to MySQL.
Opinion
David McLeman
Tim Worstall
Chris Mellor
Popular Stories
Features