postgresql mysql 和 postgres 之间的主要区别是什么？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/23382155/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
what are the main differences between mysql and postgres?
提问by Can Can
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?
我想创建一个新的 rails 应用程序，但我不确定是使用 MySQL 还是 Postgres。哪一个最好，它们之间有什么区别？
UPDATE:
更新：
The project is a health-care project. It may contain more than 500 tables.
该项目是一个医疗保健项目。它可能包含 500 多个表。
回答by shivam
postgres is secure, fast, and full of features but comparatively tricky to use.
postgres 安全、快速且功能齐全，但使用起来比较棘手。
MySql has its own benefits along with large user community and vast materials. Immensely helpful if you ever get stuck.
MySql 有其自身的优势以及庞大的用户社区和丰富的资料。如果您遇到困难，这将非常有帮助。
But ultimately it all comes to your preference and framework (apart from rails if your app requires any) support.
但最终这一切都取决于您的偏好和框架（除了 Rails，如果您的应用程序需要任何支持）。
Read this for detailed comparison and insights: http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL%3a_Comparing_Reliability_and_Speed_in_2007
阅读本文以获得详细的比较和见解：http: //wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL%3a_Comparing_Reliability_and_Speed_in_2007
