Posted 2002-10-28 15:29:30 by
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.