On Thu, Apr 06, 2006 at 10:25:38PM +0200, Joachim Schipper wrote: > I can second that. I am not a heavy database user by any means - I like > grep far too much for that - but when it can't be avoided, I'd rather > use something with a working foreign key implementation (though that > has apparently improved quite a bit in the 5.x series), and less > 'nonstandard extensions'.
Yep to the above. PostgreSQL has: *) foriegn keys *) supports ANSII SQL *) Full ACIDity *) supports views (sort of like symbolic links to entire tables, joins, etc) MySQL is a wee bit faster, but it has none of the above, so it is really just an SQL interface to a file system. If you value your data, what is the point of that?????? If you do not value your data, why bother with a database? MySQL is pointless.