Postgres quora

PostgreSQL’s Strength

It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications .

The advantages and disadvantages of PostgreSQL at a glance AdvantagesDisadvantagesHighly expandableExpandable documentation only available in EnglishLargely compliant with SQL standardComparatively low reading speedPossible to process complex data types (e.g. geographical data)Flexible full text searchPostgreSQL: features of the open source database – IONOS www.ionos.com › Digital Guide › Server › Know-how › PostgreSQL

Postgres Advantages over MySQL Postgres is an object-relational database, while MySQL is a purely relational database. This means that Postgres includes features like table inheritance and function overloading , which can be important to certain applications. Postgres also adheres more closely to SQL standards.