X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 42C4A11F6AB5 for ; Wed, 26 Apr 2006 21:04:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11716-04 for ; Wed, 26 Apr 2006 21:04:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id B831911F6AAF for ; Wed, 26 Apr 2006 21:04:31 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 5FBC156435; Wed, 26 Apr 2006 19:04:32 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 26 Apr 2006 19:04:30 -0500 Date: Wed, 26 Apr 2006 19:04:30 -0500 From: "Jim C. Nasby" To: IvoD Cc: pgsql-general@postgresql.org Subject: Re: Database Selection Message-ID: <20060427000429.GP97354@pervasive.com> References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com> <20060424230049.GH64695@pervasive.com> <1145944010.148139.26490@j33g2000cwa.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1145944010.148139.26490@j33g2000cwa.googlegroups.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060427:gordion@quick.cz::mD0g7nNfSeu1XSEy:01Xu9 X-Hashcash: 1:20:060427:pgsql-general@postgresql.org::KcyEV+TTrGOGeJHa:000000000 000000000000000000000000CjdZ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/1174 X-Sequence-Number: 94615 On Mon, Apr 24, 2006 at 10:46:50PM -0700, IvoD wrote: > My "sixth sense" tells me that PostgreSQL is better than MySQL, > therefore for main app I prefer PostgreSQL; but I am in doubt to run > only one db engine for two databases. But my "inner space" tells me to > separate newsgroups system and company data system and run two > different db engines - in light of security (although only one db > engine looks promissing). Since I haven't seen it mentioned, google for 'mysql gotchas'. About 100 reasons not to use MySQL (granted, there's some PostgreSQL gotchas as well, but there's far fewer and they're nowhere near as serious). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461