yugabyte-db

YugabyteDB is an open-source, cloud-native distributed SQL database that is PostgreSQL-compatible. It is designed for mission-critical, real-time OLTP applications that require strong consistency, high availability, and horizontal scalability. The database combines the power of traditional relational databases with the scalability of NoSQL systems, making it suitable for globally distributed deployments. Key features include: - **Powerful RDBMS capabilities**: Reuses the PostgreSQL query layer, supporting most of its features including datatypes, queries, stored procedures, triggers, and extensions. - **Distributed transactions**: Based on Google Spanner architecture, using Raft consensus for replication and hybrid logical clocks for strong consistency. Supports snapshot, serializable, and read committed isolation levels. - **Continuous availability**: Tolerates disk, rack, node, zone, region, and cloud failures automatically, with RPO of 0 and RTO of 3 seconds in typical multi-zone deployments. - **Horizontal scalability**: Easily scale by adding nodes to the cluster. - **Geo-distributed, multi-cloud**: Supports deployments across multiple fault domains, including multi-zone, multi-region, and multi-cloud, as well as xCluster asynchronous replication. - **Multi API design**: Supports two distributed SQL APIs - YSQL (fully relational, PostgreSQL-based) and YCQL (semi-relational, Cassandra QL roots). - **100% open source**: Licensed under Apache 2.0, with enterprise features like distributed backups, encryption, TLS, and change data capture included. Recent releases (v2025.2, v2025.1) have introduced PostgreSQL 15 compatibility, cost-based optimizer, bitmap scan support, parallel query execution, HNSW indexing for pgvector, and enhanced time synchronization. The project is actively developed with a clear roadmap and community support via Slack, forum, and GitHub issues.