SQL Questions (MySQL or PostgreSQL?)

Andrew L. Gould algould at datawok.com
Fri Feb 11 14:51:32 PST 2005

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.


If you need more info, visit their websites or google.

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

More information about the freebsd-questions mailing list