[jrockway]

Sybase has to be the worst of the "real databases", although SQL Server, DB2 and Oracle are bad too. The first time I tried to use Sybase, I wrote something like "CREATE TABLE foo (id INTEGER PRIMARY KEY, bar INTEGER NOT NULL)". Turns out Sybase doesn't have a type called "INTEGER". What the fuck.

Admittedly, all databases have their quirks. I use SQLite for a multi-process app suite, and get "database is locked" rather frequently. At least my app now knows how to retry transactions. Most of the apps using "real databases" fall over as soon as a transaction fails. "Internal server error, please retry later." Uh, no... transactions are supposed to fail. Even reads.

But I digress.