From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.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. <<