Overview of Popular DBMSeS – PostgreSQL

PostgreSQL, also known as Postgres, is considered to be the most advanced open source database and a more robust SQL database alternative to MySQL Postgres is also the stronger choice for workloads that are dependent on database write operations and the ability to add custom data types Postgres is open source and all features are available without a paid license for any size deployment, in contrast to MySQL

Strengths

• True Open Source: Postgres is maintained by a global community, and a single version of the software is available that contains all features and has no fees.
• Extensibility: Postgres supports a wider range of data types and indices than MySQL, and additional feature extensions are provided by the open source community
• Data Encryption Options: Multiple encrypted connection options

Weaknesses

• Server Memory Demands: Postgres forks a new process for each new client connection Connections allocate a non-trivial amount of memory (about 10 MB)
• Increased Complexity over MySQL: Postgres adheres more strongly to SQL standards so it can be a difficult starter database for standard web applications. For example, querying in Postgres is case-sensitive

Use Cases: High-Scaling Applications, Multi-Database Workloads