Re: Need Some Recent Information on the Differences between Postgres and MySql

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Wang, Mary Y
Sent: Thursday, June 24, 2010 4:05 PM
To: pgsql-general
Subject: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql

Hi,

I'm trying to find some write-ups about the differences between Postgres and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and plan to watch a recent webcast on PostgreSQL vs. MySQL that was offered by EnterpriseDB.

Are there any other most recent summaries on the differences between Postgres and MySql?
>>
An extremely important difference is the license structure:

MySQL is either GPL or commercial. If your project is GPL open source then you can use the GPL version but if not and it is a commercial project then you must purchase a commercial license.

PostgreSQL is Berkeley licensed and so you can use it with impunity for any sort of project without the need to purchase a license.

They are both nice, mature software tools and either would be suitable for doing something like setting up a web site.
<<