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

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Toni Linscomb
Answered By 0 points N/A #146277

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

qa-featured

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

Best Answer
Best Answer
Answered By 5 points N/A #146279

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

qa-featured

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. 

Answered By 0 points N/A #146278

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

qa-featured

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.

Related Questions