[Gllug] Why not to use MySQL...

[Daniel P. Berrange]

People are often asking whether to use PostgreSQL or MySQL for web
applications. Well the performance argument is pretty irrelevant these 
days, since PG has improved drammatically in the course of the 7.x 
series & is easily comparable with MySQL. So it should comes down to 
is their comparative levels of support for the SQL standards. Or in
the MySQL case, all the horrific ways in which is deviates from the
spec.

For example, if you define a table with a bunch of NOT NULL fields
and run an insert statment that doesn't set one of these fields,
you'd expect an error, right ? Well not with MySQL you won't. If
you don't supply a value, it'll make one up that seems plausible
depending on the datatype. WTF.com ?

  http://sql-info.de/mysql/gotchas.html

Let the flamewars commence.... :-)

Dan.
-- 
|=-               http://www.berrange.com/~dan/gpgkey.txt             -=|
|=-   berrange at redhat.com  -  Daniel Berrange  -  dan at berrange.com    -=|
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20031124/57337d25/attachment.pgp>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug