At 05:45 PM 2/24/2005, you wrote:
>hi,
>just want to know the main benefits of mysql over postgresql.
>thanks,
>Payam Shabanian
>
Payam,
The differences between the products are narrowing, especially
with MySQL 5.0 which is still in beta. If I could sum it up in 1 sentence
then MySQL is typically faster and Postgresql has more features. But if
you have a commercial application, the main difference is economics. You
can distribute your Postgresql application for free whether it is a
commercial application or a free application. You can distribute your MySQL
application without purchasing a MySQL license only under the GPL (you need
to release your source code). If you distribute your application outside of
the GPL you will need a MySQL license for each copy you distribute (which
is around $500). Even if you distribute your MySQL application for free
(even inside your company), you will need to distribute your source
otherwise you need a license for each copy.
Some interesting links:
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/MySQL-PostgreSQL_features.html
http://www.mysql.com/company/legal/licensing/faq.html
http://www.databasejournal.com/features/mysql/article.php/3288951
Mike
