Keith Devens .com - Weblog: Entry 1593

Sunday, March 10, 2002

Entry 1593

Holy crap, MySQL is so hopelessly broken it's ridiculous. I want to do a fairly simple query that would be a piece of cake in Access that MySQL can't even do. And MySQL won't get subqueries until version 4.1 or so, and who knows when that'll be out. Roar. Looks like I'll have to do a whole bunch of queries to replace the one that I should be able to do.

Permalink | 1 Comment | id 1593

02:13 (utc-5)

Comments

Adam Vandenberg wrote:

MySQL is good at what it does, but is NOT a full-featured RDMS. And by "not full-featured" I mean "lacks support for basic SQL that even Access can do, like sub-selects. And it could have transactions or at least better locking while it's at it."

It's good for hacking around and for simple CMS systems (ie, Slashdot runs on MySQL with few problems), but I wouldn't build an ecommerce site with it.

In my experience lots of hacks out there using MySQL don't even know the value of a JOIN(!) let alone why sub-selects are a good feature to have.

∴ Adam Vandenberg | 10-Mar-2002 4:30pm est | #58

Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

**bold**, *italic*, _underlined_, --strikeout--
"text"="url" creates a link, and URLs are auto-highlighted
Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code

RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
on 5 posts