Skip site navigation (1) Skip section navigation (2)

Re: Need concrete "Why Postgres not MySQL" bullet list

From: Ian Barwick <barwick(at)gmx(dot)net>
To: elein <elein(at)varlena(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Need concrete "Why Postgres not MySQL" bullet list
Date: 2003-08-21 21:40:49
Message-ID: 200308212340.49075.barwick@gmx.net (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers
On Thursday 21 August 2003 20:16, elein wrote:
> Ian's list is excellent.
>
> I would like to add to the point about pl languages.
>
> Use the right tool for the job:
> Procedure may be written in tcl, plpgsql, perl,
> python, R (statistics) so you can use the right tool
> for the job at hand as well as leverage your
> existing knowledge of a given scripting language.

Good point. I will try and get a working draft
together by the start of next week.

> It would help to solidify our specific examples
> of failures if the version and platform of mysql
> is included. 

Yup. I have compiled a long list of behavioural
oddities for my own reference; I've researched
many of these in the MySQL documentation (to make
sure I'm not seeing things), and an astounding number
are actually documented and show no signs of
going away, even in the 4.x series. I will install a 4.1
alpha (?) version just to be on the safe side, as this is
being touted as "the will-MySQL-make-it-into-the
enterprise-league version" (i.e. the version with sub-selects).

> Clarifications with postgresql
> functionality working correctly may be appropriate
> in some cases (also include version & platform).

Here we need to emphasize the progress made in 7.3 / 7.4,
I get the impression a lot of people still see Postgres as
the "database without the DROP COLUMN functionality"...


Ian Barwick
barwick(at)gmx(dot)net


In response to

pgsql-hackers by date

Next:From: Manfred KoizarDate: 2003-08-21 21:43:21
Subject: Re: Buglist
Previous:From: Manfred KoizarDate: 2003-08-21 21:33:10
Subject: Re: Decent VACUUM (was: Buglist)

pgsql-advocacy by date

Next:From: AutoresponderDate: 2003-08-21 22:04:14
Subject: Re: That movie
Previous:From: eleinDate: 2003-08-21 21:11:18
Subject: Re: Apparently the real competition is Sybase...

pgsql-general by date

Next:From: Manfred KoizarDate: 2003-08-21 21:43:21
Subject: Re: Buglist
Previous:From: Manfred KoizarDate: 2003-08-21 21:33:10
Subject: Re: Decent VACUUM (was: Buglist)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group