PostgreSQL

PostgreSQL is the world's most advanced open source relational database management system, with a development history stretching back to 1986 at UC Berkeley and continuous community development ever since. Trusted by millions of developers and organizations worldwide, PostgreSQL is renowned for its reliability, standards compliance, robust feature set, and exceptional extensibility.

PostgreSQL's commitment to SQL standard compliance is unmatched among open source databases, supporting an impressive range of SQL features including complex joins, foreign keys, triggers, updatable views, transactional integrity, and multiversion concurrency control (MVCC). MVCC enables concurrent read and write operations without locking, delivering high throughput for mixed workloads without the read-write conflicts that plague lock-based concurrency models.

PostgreSQL's extensibility is one of its most distinctive characteristics. Users can define custom data types, custom functions in multiple procedural languages including PL/pgSQL, PL/Python, PL/Perl, and PL/JavaScript, custom operators, custom aggregate functions, and custom index types using GiST, GIN, BRIN, and other index access methods. This extensibility has enabled the creation of specialized PostgreSQL extensions including PostGIS for geospatial data, TimescaleDB for time-series data, pgvector for vector similarity search, and Citus for horizontal sharding.

PostgreSQL's JSONB data type provides efficient storage and indexing of semi-structured JSON data, allowing developers to use PostgreSQL as a document database alongside traditional relational data without sacrificing query performance. Full-text search, array types, hstore for key-value storage, and range types extend the set of data models that PostgreSQL can efficiently handle.

PostgreSQL's logical and physical replication capabilities enable high-availability configurations, read replicas, and change data capture (CDC) pipelines. Managed PostgreSQL services are available from all major cloud providers including Amazon RDS for PostgreSQL, Google Cloud SQL for PostgreSQL, Azure Database for PostgreSQL, and Supabase, making it accessible as a fully managed cloud database.