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 171E09DC81E for ; Tue, 13 Dec 2005 13:03:55 -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 06585-06 for ; Tue, 13 Dec 2005 13:03:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.204]) by postgresql.org (Postfix) with ESMTP id 1A2B99DC85D for ; Tue, 13 Dec 2005 13:03:49 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so1272007wxc for ; Tue, 13 Dec 2005 09:03:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Zw/W/vQSXQOe2jiQChvwi6glHcnaLtBmogS/Byny81IEO8mHw4ZQI63kBSf4aaT2MUI55A4kdUcPFbgayTUN42+1yP7FvuiF9vs+/J3niZSIxKlsigiYsHUqd3riUeQ6dNMHNZim7Dp0AMwjT9WMBcoJnjcbe6wN1J8gwyx3YRg= Received: by 10.70.16.15 with SMTP id 15mr1726692wxp; Tue, 13 Dec 2005 09:03:49 -0800 (PST) Received: by 10.70.132.7 with HTTP; Tue, 13 Dec 2005 09:03:49 -0800 (PST) Message-ID: <330532b60512130903s41640eaeh28e4a1d00ebcf973@mail.gmail.com> Date: Tue, 13 Dec 2005 12:03:49 -0500 From: Mitch Pirtle To: John Mohr Subject: Re: Why is PGSQL better than MySQL Cc: pgsql-php@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.412 required=5 tests=[WHY_WAIT=0.412] X-Spam-Score: 0.412 X-Spam-Level: X-Archive-Number: 200512/20 X-Sequence-Number: 3366 On 12/12/05, 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 u= se > one versus the other. But does anyone know if there is a quasi-categorica= l > comparison of the two so that I could speak with more conviction other th= an > "I know it's better". Here is my response: In the beginning, PostgreSQL focused on implementing features and being as standards-compliant as possible. MySQL focused on raw speed, and keeping the codebase to the smallest footprint possible. The end result is that the PostgreSQL folks implemented a ton of features, and adhered to a lot of standards, and have now had plenty of time to refactor and refine the software to provide significant advances in speed and stability. MySQL is only now at the point where they are starting to implement features and consider standards. To me, this puts MySQL at the same point of PostgreSQL, just three or four years ago. Why wait? ;-) -- Mitch Pirtle Joomla! Core Developer Open Source Matters