PostgreSQL

PostgreSQL (also known as Postgres) is a powerful, open-source object-relational database system with over 35 years of active development. It is known for its reliability, feature robustness, and performance.

Overview

PostgreSQL supports a wide range of data types, including JSON, JSONB, arrays, and full-text search. It supports advanced SQL features such as window functions, CTEs, and foreign data wrappers for accessing external data sources.

Key Features

  • Full ACID compliance and multi-version concurrency control (MVCC)
  • Extensible architecture: custom data types, operators, and functions
  • JSON and JSONB support for NoSQL-like workflows
  • Full-text search without external tools
  • Read replicas and streaming replication for high availability
  • Extensions via the PostgreSQL Extension (PGXN) ecosystem

Licensing

PostgreSQL is released under the PostgreSQL License, a liberal open-source license similar to BSD or MIT. There are no restrictions on commercial use, modification, or distribution.

See PostgreSQL License for details.

Official Resources