Migrate MySQL... or not...

[Chris F.A. Johnson]

On Fri, 21 Aug 2009, Madison Kelly wrote:

> Christopher Browne wrote:
> > On Fri, Aug 21, 2009 at 10:05 AM, Madison Kelly<linux-5ZoueyuiTZhBDgjK7y7TUQ at public.gmane.org> wrote:
> > > For what you're doing, I don't think one is really better than the other.
> > > 
> > > I general though; I've come to see the differences as:
> > > 
> > > MySQL; Faster, More features
> > > PostgreSQL; More Robust/Reliable, More compliant to the SQL standards.
> > 
> > MySQL *used* to be consistently faster, back about 8 years ago, but if
> > you're using any of the more modern storage engines, it's not obvious
> > that this is still the case.  There's a real paucity of good
> > benchmarks.
> > 
> > As for "more features," that hasn't ever been *remotely* close to
> > being the case.
> > 
> > MySQL(tm) was created as the "hacking on" of an SQL parser to a B-tree
> > implementation and has always been feature-impoverished.
> > 
> > In contrast, Postgres was a research project into experimental
> > database features, so that it *began* its life with stuff that other
> > DBs don't commonly have, such as the rules system.  See
> > <http://www.postgresql.org/docs/current/static/rules.html> which
> > references the relevant theoretical papers from the 1980s.
> > 
> > Give special note to:
> >  - The POSTGRES data model
> >  - The case for partial indexes
> >  - On Rules, Procedures, Caching and Views in Database Systems
> > 
> > These were presented as research in the '80s and early '90s; they were
> > part of the implementation long before MySQL(tm) existed.
> 
> Perhaps a neatral view-point comparison on SQL engines would make a good TLUG
> talk?

   Isn't anyone who really knows the subject unlikely to be neutral?

   A *fair* comparison (or contrast) would be good.

-- 
   Chris F.A. Johnson, webmaster         <http://woodbine-gerrard.com>
   ===================================================================
   Author:
   Shell Scripting Recipes: A Problem-Solution Approach (2005, Apress)
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists