MySQL Gotchas - I don’t use MySQL anymore mostly because PostgreSQL (installing it, admin tasks, etc.) does everything I need at the speed I need. I’m very surprised by all the cases in MySQL where, if you’re going against some specification (like trying to insert an overflowing 99999999999999 into a INT column) it silently tries to massage what you’re doing into something that works. The silently part is what kills me – not something you’d expect from your database.
(Found from a hurstdog post on Joel on Software.)