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 616859DC85A for ; Tue, 13 Dec 2005 12:56:36 -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 04466-08 for ; Tue, 13 Dec 2005 12:56:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web33305.mail.mud.yahoo.com (web33305.mail.mud.yahoo.com [68.142.206.120]) by postgresql.org (Postfix) with SMTP id A57159DC81E for ; Tue, 13 Dec 2005 12:56:33 -0400 (AST) Received: (qmail 19312 invoked by uid 60001); 13 Dec 2005 16:56:32 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=tKcOA/ZmxcWJJQEKyJTcDudk2KYk5/h67E7z6ZkkvSL7ynpt4aHYDUx2iaa5HyfUqkUcfatyIoaJ5PEx/HPqYWcCT7quGhUin0Hr4K9DISVxeu9mveuvqUS+5IyXqAg6f54hrvVCE0fxr5Xqs2Q1Y1XddxLcbGv5RgEBIkVuPzc= ; Message-ID: <20051213165632.19310.qmail@web33305.mail.mud.yahoo.com> Received: from [12.9.179.126] by web33305.mail.mud.yahoo.com via HTTP; Tue, 13 Dec 2005 08:56:32 PST Date: Tue, 13 Dec 2005 08:56:32 -0800 (PST) From: Subject: Re: Why is PGSQL better than MySQL To: John Mohr , pgsql-php@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.923 required=5 tests=[AWL=-0.106, DNS_FROM_RFC_ABUSE=0.479, NO_REAL_NAME=0.55] X-Spam-Score: 0.923 X-Spam-Level: X-Archive-Number: 200512/19 X-Sequence-Number: 3365 --- 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". > John, when i first started developing in open source, i did a lot of research on dbs. mysql had a HUGE, HUGE, HUGE advantage in documentation at the time - and that was a big factor since i'd be starting from scratch. i chose postgrsql inspite of this. native foreign key constraints was a big reason. i came to like transactions and it is more sql compliant than mysql. it is also less buggy. the license is also much more application developer friendly - and this is HUGE if you ever want to develop a product and market it. having said that, mysql is an INCREDIBLY popular database. those people that know it inside and out will not be inclined to change easily - the devil you know is better than the devil you don't know... while i'd choose pgsql 10/10 times, a 5 year veteran of mysql will likely choose mysql 10/10 times - and that developer may well be an excellent developer and that may be the right choice for him/her. now, if you are going to be developing apps as part of a team of folks who want to use mysql, that would be tough. i'd want to use postgresql, too. do your research regarding sql compliance, bug issues and hacked "features" in mysql that were designed into postgresql natively. this isn't a run down on mysql, either. it is a fact they hacked in features after the fact. a good mysql developer may be able to tweak the system so it works fine, but i prefer to avoid the jumping and the hoops. mysql has a reputation for being blazing fast... but i have to say my postgresql db on our lan is blink of the eye fast, too - although my records are currently in the 100s, not 100,000s. best of luck. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com