From owner-freebsd-questions@FreeBSD.ORG Fri Feb 11 22:51:32 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2E70016A4CE for ; Fri, 11 Feb 2005 22:51:32 +0000 (GMT) Received: from smtpauth09.mail.atl.earthlink.net (smtpauth09.mail.atl.earthlink.net [209.86.89.69]) by mx1.FreeBSD.org (Postfix) with ESMTP id DDF0A43D39 for ; Fri, 11 Feb 2005 22:51:31 +0000 (GMT) (envelope-from algould@datawok.com) Received: from [206.255.31.21] (helo=[192.168.63.10]) by smtpauth09.mail.atl.earthlink.net with asmtp (TLSv1:RC4-MD5:128) (Exim 4.34) id 1CzjdJ-0000yk-Tc; Fri, 11 Feb 2005 17:51:30 -0500 From: "Andrew L. Gould" To: freebsd-questions@freebsd.org, rsh.lists@comcast.net Date: Fri, 11 Feb 2005 16:51:59 -0600 User-Agent: KMail/1.6.2 References: <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net> In-Reply-To: <420D2F12.8020808@comcast.net> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200502111651.59707.algould@datawok.com> X-ELNK-Trace: ee791d459e3d6817d780f4a490ca69563f9fea00a6dd62bc50fa0f65c10ab2e685f17219e679abf5350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 206.255.31.21 cc: Jan Branbergen Subject: Re: SQL Questions (MySQL or PostgreSQL?) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Feb 2005 22:51:32 -0000 On Friday 11 February 2005 04:17 pm, Sean wrote: > > What is the difference between PostgreSQL and MySQL? > From what I see MySQL seems to be more common. > > Sean What.....not enough holy wars this week? ;-) PostgreSQL and MySQL are both good database server applications. Here are some links that you might find useful. http://www.builderau.com.au/architect/database/0,39024547,20266351,00.htm http://www.databasejournal.com/features/mysql/article.php/3288951 If you need more info, visit their websites or google. http://www.mysql.com/ http://www.postgresql.org/ MySQL is very popular for web applications. From a marketing perspective, it benefited greatly from the acronym "LAMP". If you're distributing database applications, you'll probably prefer PostgreSQL's license. My personal preference is PostgreSQL. I use it for data analysis and database applications that use MS Access as a desktop front-end. It's been fast and rock-solid. The current version, version 8, is the first version with a port that is native to Windows. I also share certain public data with Windows users with laptops. Since MySQL uses less disk space to store the database and has had a Windows version for several years, it was the better choice for their needs. As I said, both are good database servers. You have to match the server to your own needs. Andrew Gould