postgres vs Mysql [英] postgres vs Mysql
问题描述
我需要决定使用哪个数据库系统。什么是关于PostGres与MySql的流行观点
？
谢谢，
Santosh
I need to decide on which database system to use for our company. What is
the popular opinion on PostGres vs. MySql?
Thanks,
Santosh
推荐答案
OneSolution写道：
OneSolution wrote:
我需要决定使用哪个数据库系统。什么是关于PostGres与MySql的流行观点？
谢谢，
Santosh
I need to decide on which database system to use for our company. What is
the popular opinion on PostGres vs. MySql?
Thanks,
Santosh
嘿，
从我收集的内容来看，MySQL旨在处理轻量级应用程序，例如BBs系统，CMS系统等b $ b ... Postgres SQL更重，
能够处理更高的服务器负载和更多数据。
当然我不确定这是否属实，这正是我收集的内容<从我听到和看到他们的小人物中获得
。如果这是真的，那么作为一个
的公司，你可能想和Postgres一起去。再一次，我不是完全确定这是否是主要区别。
-Eric Kincl
Hey,
From what I gather, MySQL is designed to handle lighter-weight applications,
such as BBs sytems, CMS systems, etc... Postgres SQL is more heavy-weight,
able to handle higher server loads and more data.
Of course I''m not sure if this is true, this is just what I have gathered
from the little I heard and seen about them. If it is true, then as a
company you would probably want to go with Postgres. Once again, I''m not
completely sure if this is the main difference or not.
-Eric Kincl
Am Thu，2003年11月20日08:04:30 +0000帽子Eric Kincl
< Er ** @ Kincl.net_NO_SPAM_> geschrieben：
Am Thu, 20 Nov 2003 08:04:30 +0000 hat Eric Kincl
<Er**@Kincl.net_NO_SPAM_> geschrieben:
从我收集的内容来看，MySQL旨在处理轻量级的应用程序，例如BBs系统，CMS系统等......
From what I gather, MySQL is designed to handle lighter-weight
applications, such as BBs sytems, CMS systems, etc...
你从哪里得到这个？
看看这个并再说一遍。 :-)
http://www.eweek.com/slideshow/0,301...o=2&i=1,00.asp
http://www.eweek.com/slideshow/0,301...o=1&i=1,00.asp
问候，
< br $>
-
Alexander M. Turek
< ra *** @ users.sourceforge.net>
phpMyAdmin项目
< http://www.phpmyadmin.net>
Where did you get this from?
Have a look at this and speak again. :-)
http://www.eweek.com/slideshow/0,301...o=2&i=1,00.asp
http://www.eweek.com/slideshow/0,301...o=1&i=1,00.asp
Regards,
--
Alexander M. Turek
<ra***@users.sourceforge.net>
The phpMyAdmin Project
<http://www.phpmyadmin.net>
>>我需要决定为我们公司使用哪个数据库系统。什么是
>>I need to decide on which database system to use for our company. What is
关于PostGres与MySql的流行观点？
the popular opinion on PostGres vs. MySql?
MySQL很好即使是非常大的应用程序。它的缺点是：
1）。数据库更新相对较慢。这是因为MySQL锁定整个表格来执行写操作。对于大部分查询
应用程序来说不是问题。对于INNODB的支持，这应该会更好，但我没有尝试过它。$ / b
2）。不支持存储过程或视图。这可能是为什么有些人说它不具备可扩展性。如果您对每个团队都有访问限制的分布式开发的要求那么
MySQL将不起作用。你可以通过编写一个
应用程序类库来解决这个问题（无论如何都要在较大的php应用程序中进行实践）。
我觉得不合格谈论PostGres
MySQL is fine even for very large applications. Its shortcomings are:
1). Database updates are relatively slow. This is because MySQL locks
the whole table to do a write. Not a problem for largely query
applications. This should be better with INNODB support but I haven''t
tried it.
2). There is no support for stored procedures or views. This is probably
why some people say it isn''t scalable. If you have requirements for
distributed development with access restrictions for each team then
MySQL will not work. You can get round this somewhat by writing an
application class library (good practice in larger php apps anyway).
I don''t feel qualified to talk about PostGres
这篇关于postgres vs Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
