SQL

PostgreSQL – object-relational database

PostgreSQL is an object-relational database management system designed for applications requiring transactional integrity, sophisticated queries and extensible data management.

The database implements a substantial portion of the SQL standard while providing additional features for complex data types, procedural programming and custom database functionality. It supports both conventional relational structures and semi-structured information.

PostgreSQL uses multi-version concurrency control to allow readers and writers to operate concurrently without unnecessary blocking. Its extensibility allows additional functions, operators, index methods and data types to be incorporated into the database engine.

This is free and open source software.

Key Features

  • ACID transactions with multiple isolation levels, savepoints and two-phase commit.
  • Supports foreign keys, constraints, triggers, views and materialized views.
  • Provides JSON and JSONB data types with indexing and query operators.
  • Offers B-tree, hash, GiST, SP-GiST, GIN and BRIN indexes.
  • Supports common table expressions, recursive queries, window functions and lateral joins.
  • Includes built-in full-text search and advanced regular expression support.
  • Provides table partitioning, parallel query execution and sophisticated query planning.
  • Supports logical and physical replication, streaming replication and point-in-time recovery.
  • Offers row-level security, granular privileges and multiple authentication mechanisms.
  • Extensible through custom types, functions, operators and extensions.
  • Supports procedural functions, including PL/pgSQL.
  • Cross-platform support – runs on Linux, macOS, and Windows.

Website: postgresql.org
Support:
Developer: PostgreSQL Global Development Group
License: PostgreSQL License

PostgreSQL is written in C. Learn C with our recommended free books and free tutorials.


Related Software

Relational Databases
MariaDBHigh compatibility with MySQL, ensuring drop-in replacement capability
PostgreSQLAward winning Object-relational database management system
MySQLMultithreaded, multi-user SQL database management system
SQLiteEmbeddable SQL Database Engine
TiDBCloud-native, distributed SQL database
DuckDBIn-process SQL OLAP database management system
TursoIn-process relational database engine
YugabyteDBPostgreSQL-compatible distributed SQL database
rqliteDistributed database built on SQLite
MonetDBHigh performance relational database system for analytics
DoltVersion-controlled SQL database
FirebirdRelational database offering many ANSI SQL features
H2Relational database management system written in Java
HSQLDBJDBC interface, client-server version, query tool, grid and more
CUBRIDDatabase engine with built-in enterprise grade features
Apache CloudberryMassively parallel processing database
VirtuosoData Management with Web Application Server and Web Services
Apache DerbyFull-featured relational database implemented entirely in Java

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
2 Comments
Oldest
Newest Most Voted
Valter Ekholm
Valter Ekholm
8 years ago

I read “Hot standby” two times from the list, a duplicate.