what are the main differences between mysql and postgres? [closed]

Question

I want to create a new rails application and I'm not sure whether to use MySQL or Postgres. Which one is best and what is the difference between them?

UPDATE:

The project is a health-care project. It may contain more than 500 tables.

Answer 1

postgres is secure, fast, and full of features but comparatively tricky to use.

MySql has its own benefits along with large user community and vast materials. Immensely helpful if you ever get stuck.

But ultimately it all comes to your preference and framework (apart from rails if your app requires any) support.

Read this for detailed comparison and insights: http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL%3a_Comparing_Reliability_and_Speed_in_2007