vs

PostgreSQL review and compare

PostgreSQL, often simply Postgres, is an object-relational database management system with an emphasis on extensibility and standards compliance.

Information

Website

postgresql.org

Type

ORDBMS

Developer

PostgreSQL Global Development Group

Initial release

8 July 1996

Cost

Free

Development status

Active

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.

License

  • DFSG compatible: Yes
  • FSF approved: Yes
  • OSI approved: Yes
  • GPL compatible: Yes
  • Copyleft: No
  • Linking from code with a different license: Yes

Price

$0

Size

  • MacOs: 124Mb
  • Windows: 150Mb
  • Linux: 116Mb

Source model

Open Source

Stable release

8 July 1996

Written in

C

Access Methods

Supports all standards

ACID Compliance

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.

Community Support

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.

Performance

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 supports a wide variety of programing languages including: C/C++, Java, JavaScript, .Net, R, Perl, Python, Ruby, Tcl and others; it’s even possible to run user-supplied code in separate processes (i.e. running as background workers).

Security

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

Cons

  • 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

Pros

  • 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