Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 11 Feb 2005 16:51:59 -0600
From:      "Andrew L. Gould" <algould@datawok.com>
To:        freebsd-questions@freebsd.org, rsh.lists@comcast.net
Cc:        Jan Branbergen <jan@evation.com>
Subject:   Re: SQL Questions (MySQL or PostgreSQL?)
Message-ID:  <200502111651.59707.algould@datawok.com>
In-Reply-To: <420D2F12.8020808@comcast.net>
References:  <20050211115902.5BCC643D3F@mx1.FreeBSD.org> <420D2F12.8020808@comcast.net>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200502111651.59707.algould>