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
Great Review (Anonymous on may 2013 microblog digest)
Outlook Support Phone Number (Anonymous on take a key for coming in)
Aol Support Phone Number (Anonymous on take a key for coming in)
Sage Support Phone Number (Anonymous on take a key for coming in)
Quicken Support Phone Number (Anonymous on take a key for coming in)
Quickbooks Technical Support Phone Number (Anonymous on take a key for coming in)
http://outlook
tech.supportph
one-number.com
/ (Anonymous on take a key for coming in)
Aol Support Number (Anonymous on take a key for coming in)
Sage Support Number (Anonymous on take a key for coming in)
Quicken Support Number (Anonymous on take a key for coming in)
QuickBooks Support Number (Anonymous on take a key for coming in)
Do you know how to get Sage 50 Support (Anonymous on comments are back)
Do you know how to get Sage 50 Support (Anonymous on eye-tracking)
Packers And Movers Bangalore Local Shifting Charges (Anonymous on may 2014 microblog digest)
ISO 9001 Certification in Bangalore (Anonymous on eye-tracking)
Comments RSS