[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: (OT: PostgreSQL vs MySQL)
- To: misc_(_at_)_openbsd_(_dot_)_org
- Subject: Re: (OT: PostgreSQL vs MySQL)
- From: Joachim Schipper <j_(_dot_)_schipper_(_at_)_math_(_dot_)_uu_(_dot_)_nl>
- Date: Fri, 7 Apr 2006 11:18:01 +0200
- Mail-followup-to: misc_(_at_)_openbsd_(_dot_)_org
On Fri, Apr 07, 2006 at 01:17:15AM +0100, Craig Skinner wrote:
> 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,
> 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.
Not necessarily - a lot of PHP script rely on a database, but I do not
think our forum constitutes critical data. ;-)
That being said, the above forum is run on PostgreSQL.