Why does everyone love MySQL?

So I found out why MT-Blacklist wouldn’t accept my settings. It turns out it has nothing to do with MT-Blacklist, but rather MT 3.12 (and other versions, no doubt), have a bug which prevents plugins from saving data when using Postgres. This really irritates me.

See: http://www.rayners.org/2004/06/getting_postgre.php

For one, it bugs me because MovableType is now commercial software and appears to not be thoroughly tested. But since I didn’t pay for it (I’m using the free version, for now), I can’t really complain too much about that. If only it was written in Java, then I could fix the crap out of it. My perl hacking days have long passed.

The other reason I’m annoyed is because the open source community (of which MT was part of until recently) continues to rely on MySQL as if it is the only DB in the universe. Look, I am heavily involved in the open source community, as many of you know. But the real world has taught me that not only is MySQL not used everyone, it also really sucks!.

I mean come on — no foreign key constraints? Are you kidding? And I guess sub-selects were just recently added. People: let’s get real and start using some real DBs.