BEGIN:VCALENDAR
VERSION:2.0
X-WR-CALNAME:03/05/2007: MySQL WTF?!
X-WR-CALDESC:I’m currently in the process of extending demiblog’s database support. Version 0.1.0 only supports PostgreSQL, but I plan on also supporting MySQL in the next release, and a few other databases further down the line.  Because this cross-database support had always been planned, I’ve been very careful in writing my SQL to make sure that only standards-compliant syntax is used, and there are no proprietary PostgreSQL extensions.  I always knew that I’d have to adjust my SQL slightly to get it to run on other databases, but the amount of changes needed to port a seemingly simple SQL script with less than 300 lines to MySQL was astounding! Although a few of the adjustments were needed to account for SQL features that MySQL simply doesn’t yet support, the majority were to take into account several of MySQL’s seemingly-gratuitous bastardisations of the standard SQL syntax.  MySQL, how do I hate you, let me count the…
BEGIN:VJOURNAL
DTSTART:20071103T185250Z
DTEND:20071103T185250Z
URL:http://tobyinkster.co.ukhttp://tobyinkster.co.uk/blog/2007/05/03/mysql-wtf/comments#comment1
SUMMARY:Comment 001
CATEGORIES:
STATUS:NEEDS-ACTION
END:VJOURNAL
END:VCALENDAR