From: David Rogers <David.Rogers@MCI.com>
To: John Mohr <jtmohr@healthconresources.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Why is PGSQL better than MySQL
Date: Tue, 13 Dec 2005 08:36:12 -0600
Message-ID: <1134484572.2948.14.camel@nsoc6522c.mcilink.com> (raw)
In-Reply-To: <IHEBIKJHMMKHJKLKCDHLMEMMFFAA.jtmohr@healthconresources.com>
References: <IHEBIKJHMMKHJKLKCDHLMEMMFFAA.jtmohr@healthconresources.com>
On Mon, 2005-12-12 at 20:02 -0600, John Mohr wrote:
> I've been reading the "AP2" thread and take it as a matter of faith
> that PGSQL is better than MySQL. It seems more complete for one thing.
> I have tried to explain my reasoning to several people when convincing
> them to use one versus the other. But does anyone know if there is a
> quasi-categorical comparison of the two so that I could speak with
> more conviction other than "I know it's better".
I have been a serious MySQL user for several years and was looking
forward to the 5.0 release so that I could employ triggers and stored
procedures in some of our applications. While attempting to convert from
MySQL 4.1 to 5.0 this past summer we uncovered numerous serious bugs in
MySQL all of which were reported. We subsequently discovered many of
these same bugs in version 4.1. None of the reported bugs have yet been
fixed in any version. Additionally the implementation of stored
procedures and triggers is so useless that it is laughable that they
even bothered to mention it as a feature.
Needless to say, this fall we began the conversion to PostgreSQL 8 and
we couldn't be more pleased. As a part of the conversion I found several
new bugs in MySQL due to PostgreSQL complaining about some of my old
queries. The most egregious of these are MySQL silently truncating var
chars that are too long for the column and silently allowing one to
insert a quoted string into an integer column. Ouch! We won't be using
MySQL for any new work here and will eventually migrate all of our
applications to PostgreSQL.
My heartiest congratulations to the entire PostgreSQL team for an
absolutely outstanding product!
dave
--
David Rogers
vnet 777-6522
MCI Network Security Operations Center
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: David.Rogers@MCI.com, jtmohr@healthconresources.com
Subject: Re: Why is PGSQL better than MySQL
In-Reply-To: <1134484572.2948.14.camel@nsoc6522c.mcilink.com>
References: <IHEBIKJHMMKHJKLKCDHLMEMMFFAA.jtmohr@healthconresources.com> <1134484572.2948.14.camel@nsoc6522c.mcilink.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox