Why is PostgreSQL so popular?

features and performance as well as scalability make it a proper alternative for applications where traditionally Oracle DB was hard to replace. its more recent features for Key-Value-Storage (JSON / JSONB column type) make it an alternative to NoSQL-databases. PostgreSQL supports clustering / Master-Slav.

Read more

When should I use PostgreSQL?

In general, PostgreSQL is best suited for systems that require execution of complex queries, or data warehousing and data analysis . MySQL is the first choice for those web-based projects which require a database merely for data transactions and not anything intricate.

Read more