PostgreSQL

PostgreSQL is the most advanced open source object-relational database system. It extends the SQL language combined with many features that safely store and scale the most complicated data workloads. It runs on all major operating systems, has been ACID-compliant since 2001, and has powerful add-ons such as the popular PostGIS geospatial database extender.

It started its operations in 1986 as a part of POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

PostgreSQL is known for its reputation, as it has continuously proven its architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver per formant and innovative solutions.

PostgreSQL Features:

PostgreSQL runs on advanced features such as User-defined types, contains Table inheritance, Sophisticated locking mechanism, maintained with Foreign key referential integrity, Multi-version concurrency control (MVCC),Nested transactions (savepoints) and Asynchronous replication