How is PostgreSQL different from other databases?

Question

PostgreSQL has a lot of capability. Built using an object-relational model, it supports complex structures and a breadth of built-in and user-defined data types. It provides extensive data capacity and is trusted for its data integrity. 8 окт. 2015 г.

What are the advantages of Postgres over other types of databases?

BENEFITS OF POSTGRESQLOpen Source. Source code is freely available under an open source license. ... Reduce costs. As a true open source product, PostgreSQL does not cost anything – no licence fees! ... Community-driven – Reliability. ... Security. ... Scalability.

What is different about PostgreSQL?

PostgreSQL is an object-relational database, while MySQL is purely relational. This means PostgreSQL offers more complex data types and allows objects to inherit properties, but it also makes working with PostgreSQL more complex. PostgreSQL has a single, ACID-compliant storage engine.

What is special about PostgreSQL?

PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions.

Why PostgreSQL is the best database?

Totally integrated data storage and access—a truly multi-model database. PostgreSQL's speed, security and robustness make it suitable for 99% of applications, so it's a great starting place for any application. Maybe, just maybe, other systems have some other magic you need.

Expert · Answer