Re: (OT: PostgreSQL vs MySQL)

[Craig Skinner <craig_(_dot_)_skinner_(_at_)_kepax_(_dot_)_co_(_dot_)_uk>]

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.