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 we give you the numbers. use the numbers!)
no subject (Anonymous on #weightedsixes
: back and with more bots than ever)
no subject (Anonymous on i didn't say it, he said it)
no subject (Anonymous on digital: a love story -- one-hour review)
no subject (Anonymous on clipping a line segment to a triangle)
no subject (Anonymous on dance dance revolution in the future)
no subject (Anonymous on the best way to eat beans)
no subject (Anonymous on gta3 for gba: the burning question)
no subject (Anonymous on duke nukem forever -- one-hour review)
no subject (Anonymous on take a key for coming in)
no subject (Anonymous on super monkey ball 2 mini-review)
no subject (Anonymous on bioshock, system shock 2, and fear)
no subject (Anonymous on tim's working on physics)
no subject (Anonymous on a review of actionbutton.n
et)
no subject (Anonymous on experts; atari 2600 display hardware)
Comments RSS