goombas.org
menu
main
links
all items
rss feed

Topics:
coding
games
goombas.org
horror
judgement
life
minutiae
music
rants
software
fool.
 _-
 oO
 |/
/|
/ \
Ugh, stop twitching
mysql displeases me
coding Posted 2002-10-28 15:29:30 by Jim Crawford
I just finished the switchover for goombas.org from [database engine goombas.org was using before] to MySQL. MySQL displeases me in its lack of adherence to the SQL standard. Yes, it's zippy and scalable, but even [database engine goombas.org was using before] at least uses the standard quoting rules.

In case you missed this issue, MySQL uses \ to literalize the next character inside quoted strings. But MySQL supports the '' sequence too, just to ensure that a programmer working from experience with real SQL databases thinks his code is working when it's really not.

What were these idiots thinking? This is the same embrace-and-extend philosophy that's driven the open source community to hate Microsoft... except in this case, you're not actually extending anything, just mutilating standards for no apparent reason. Except maybe that you like C a lot. And as a result, posting a message with the content “\'); delete from posts #” trashes probably 250% more message boards than it rightfully ought to.

[link to this] [See more on “coding”]

comments
add a comment
Only anonymous comments are available for now until I get the user system up and running again. Not many people were logging in anyway, so enh.
Permitted HTML tags: <b>, <i>, <u>, <tt>. Also permitted is the <q> pseudo-tag which is meant to delimit quotes from other messages.
name:
email:
subject:
body:
Preview
To prove you are sentient, please type "sentient" into this box

what's this?
This is Jim Crawford's blog. Details and contact information.

On Twitter: @mogwai_poet

recent comments
no subject (Anonymous on may 2013 microblog digest)
no subject (Anonymous on boxing: a history)
QuickBooks Technical Support Phone Number @1844-640-1482
(Anonymous on may 2013 microblog digest)
phone number for quickbooks support (Anonymous on may 2013 microblog digest)
no subject (Anonymous on boxing: a history)
Accountancy (Anonymous on may 2013 microblog digest)
QuickBooks Technician (Anonymous on may 2013 microblog digest)
no subject (Anonymous on boxing: a history)
quickbooks support (Anonymous on may 2013 microblog digest)
Loved the game (Anonymous on boxing: a history)
no subject (Anonymous on may 2013 microblog digest)
no subject (Anonymous on may 2013 microblog digest)
Aol Tech Support Number (Anonymous on may 2013 microblog digest)
Time Mushyn (Anonymous on foolish 2)
Packers and Movers Bangalore (Anonymous on may 2013 microblog digest)
Comments RSS