Postgres

Open-source object-relational database system that extends SQL with advanced data types, indexing, and concurrency control. Designed for reliability, data integrity, and performance across workloads from small applications to multi-terabyte clusters.

PostgreSQL has been in active development for over 35 years and conforms to 170 of 177 mandatory SQL:2023 Core features, leading open-source relational databases in standard adherence. The project is maintained by 700+ contributors and powers millions of applications worldwide. It stands out from MySQL and other alternatives through deep extensibility: custom data types, procedural languages such as PL/pgSQL and Python without recompiling, and a rich extension ecosystem including PostGIS for geospatial workloads.

Key capabilities:

• ACID compliance with MVCC, full transaction isolation levels, and write-ahead logging for durability
• JSON/JSONB, arrays, ranges, UUID, and full-text search alongside traditional relational types
• Advanced indexing: B-tree, GIN, GiST, SP-GiST, BRIN, plus covering and partial indexes
• Extensibility via stored procedures, foreign data wrappers, and pluggable languages
• Logical and streaming replication, point-in-time recovery, and row-level security

Common fits: transactional applications, analytics backends, geospatial systems with PostGIS, and document stores using JSONB. Developers integrate with standard drivers and ORMs, run it on-premises or via managed cloud offerings, and extend it for vector search via pgvector or custom logic in preferred languages.