This post originated from an RSS feed registered with Java Buzz
by Chris Winters.
Original Post: Peek-a-boo logic in MySQL
Feed Title: cwinters.com
Feed URL: http://www.cwinters.com/search/registrar.php?domain=jroller.com®istrar=sedopark
Feed Description: Chris Winters on Java, programming and technology, usually in that order.
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.