PostgreSQL review and compare
PostgreSQL, often simply Postgres, is an object-relational database management system with an emphasis on extensibility and standards compliance.
DeveloperPostgreSQL Global Development Group
Initial release8 July 1996
Hard disk space
- 512MB of minimum disk space is required for installing the software.
- 256MB of free disk space is required for job result directory.
- 256MB of free disk space is required for log directory.
- DFSG compatible: Yes
- FSF approved: Yes
- OSI approved: Yes
- GPL compatible: Yes
- Copyleft: No
- Linking from code with a different license: Yes
- MacOs: 124Mb
- Windows: 150Mb
- Linux: 116Mb
Source modelOpen Source
Stable release8 July 1996
Access MethodsSupports all standards
PostgreSQL is ACID compliant from ground up and ensures that all requirements are met.
Cloud Hosting Suports
Supported by all major cloud service providers, including Amazon, Google, & Microsoft.
PostgreSQL has a very strong and active community that constantly improves existing features while its innovative committers strive to ensure it remains the most advanced database with new cutting-edge features and security.
PostgreSQL is widely used in large systems where read and write speeds are crucial and data needs to validated. In addition, it supports a variety of performance optimizations that are available only in commercial solutions such as Geospatial data support, concurrency without read locks, and so on (e.g. Oracle, SQL Server).
Programming Languages Support
PostgreSQL has ROLES and inherited roles to set and maintain permissions. PostgreSQL has native SSL support for connections to encrypt client/server communications. It also has Row Level Security.
In addition to this, PostgreSQL comes with a built-in enhancement called SE-PostgreSQL which provides additional access controls based on SELinux security policy. More details here.
NoSQL Features/JSON Support
Multiple supported features
- Documentation can be spotty, so you may find yourself searching online in an effort to figure out how to do something
- Configuration can be confusing
- Speed may suffer during large bulk operations or read queries
- This database management engine is scalable and can handle terabytes of data
- It supports JSON
- There are a variety of predefined functions
- A number of interfaces are available