Which is the best open source database? MySQL or PostgreSQL?

Asked By robert l mathis 0 points N/A Posted on - 11/06/2012

I want to choose the best open source database. I have heard that  MySQL or PostgreSQL are the best but which are really the main differences?

• Status: Open
• Question Views: 953
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: dBase

Best Answer by Toni Linscomb

Go To Solution

Answered By Thornton Patricia 0 points N/A #146277

Which is the best open source database? MySQL or PostgreSQL?

Hi,

Using mysql or postgresql is mainly depends on preference of development team or professionals commonly features are flexible working and stable with systems they working. mysql is faster in performance wise where as postgresql is slow.

Postgresql supports foreign key, view, stored procedure but my sql do not and in mysql able to use different table types most preference for mysql is considering requirements of database.

Hope these shall helps you

Thanks

About Thornton Patricia

Questions
3

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 11/06/2012
• Question Category: dBase

Best Answer

Best Answer

Answered By Toni Linscomb 5 points N/A #146279

Which is the best open source database? MySQL or PostgreSQL?

These kinds of comparisons are always depends on very sensitive information.

However MYSQL is supported by many hosting providers and used by many programmers and clients than PostgreSQL. PostgreSQL can also be known as a mature product.

When it comes to the performance which is the most important factor of any web system MYSQL is fast when it has low number of concurrent access levels and slows down a bit when there are many concurrent reads/writes.

On the other hand PostgreSQL is bit slow even on low number of concurrent access levels but when there are more access levels it scales it down and manages those concurrent access level very well.

So the question which is better actually depends on what really matters. 

About Toni Linscomb

Questions
0

Answers
197

Best Answers
86

• Vote Up 0 Vote Down

• Posted on - 11/07/2012
• Question Category: dBase

Answered By Deborah Antoaneta 0 points N/A #146278

Which is the best open source database? MySQL or PostgreSQL?

Hello Robert!

MySQL is the best database for the web. MySQL's over 3,000 ISV / OEM customers range from Dell.

MySQL is technically well suited for embedded use as well as the related business.

MySQL Embedded Server provided both the best functionality and price point.

The second one is PostgreSQL:

PstgreSQL is slower and more complicated to use.

About Deborah Antoaneta

Questions
3

Answers
81

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 11/10/2012
• Question Category: dBase