X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 480239DC82A for ; Tue, 13 Dec 2005 10:44:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75581-01 for ; Tue, 13 Dec 2005 10:44:14 -0400 (AST) X-Greylist: delayed 00:05:00.339157 by SQLgrey- Received: from omzesmtp02.mci.com (omzesmtp02.mci.com [199.249.17.9]) by postgresql.org (Postfix) with ESMTP id 25FFF9DC819 for ; Tue, 13 Dec 2005 10:44:08 -0400 (AST) Received: from dgismtp04.wcomnet.com ([166.38.58.144]) by firewall.mci.com (Iplanet MTA 5.2) with ESMTP id <0IRF00G02XYETQ@firewall.mci.com> for pgsql-php@postgresql.org; Tue, 13 Dec 2005 14:37:26 +0000 (GMT) Received: from dgismtp04.wcomnet.com by dgismtp04.mcilink.com (iPlanet Messaging Server 5.2 HotFix 1.14 (built Mar 18 2003)) with SMTP id <0IRF00701XRDM7@dgismtp04.mcilink.com>; Tue, 13 Dec 2005 14:37:26 +0000 (GMT) Received: from nsoc6522c.mcilink.com ([166.50.73.126]) by dgismtp04.mcilink.com (iPlanet Messaging Server 5.2 HotFix 1.14 (built Mar 18 2003)) with ESMTP id <0IRF007A1XWCM4@dgismtp04.mcilink.com>; Tue, 13 Dec 2005 14:36:12 +0000 (GMT) Date: Tue, 13 Dec 2005 08:36:12 -0600 From: David Rogers Subject: Re: Why is PGSQL better than MySQL In-reply-to: To: John Mohr Cc: pgsql-php@postgresql.org Message-id: <1134484572.2948.14.camel@nsoc6522c.mcilink.com> MIME-version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-type: text/plain; CHARSET=us-ascii Content-transfer-encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.333 required=5 tests=[RCVD_IN_BL_SPAMCOP_NET=1.332, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 1.333 X-Spam-Level: * X-Archive-Number: 200512/18 X-Sequence-Number: 3364 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