CockroachDB Database

CockroachDB is a distributed SQL database created by Spencer Kimball, Peter Mattis, and Ben Darnell in 2015, developed by Cockroach Labs, headquartered in New York, providing PostgreSQL-compatible SQL with horizontal scalability, strong consistency through distributed transactions, automatic data replication across multiple regions, and survivability through fault tolerance, written in Go for performance and portability, designed to be the database that survives disk failures, machine failures, rack failures, data center failures, and even region failures without data loss, adopted by companies including DoorDash, Netflix, and Bose for their mission-critical transactional workloads that require both SQL compatibility and horizontal scale. The distributed architecture uses a range-based sharding model where tables are automatically split into ranges of approximately five hundred megabytes, with each range replicated across at least three nodes using the Raft consensus algorithm for strong consistency, ensuring that every write is durably replicated before acknowledging the client. The PostgreSQL compatibility means applications written for PostgreSQL can connect using standard PostgreSQL drivers and wire protocol, with support for transactions, joins, subqueries, window functions, JSON types, and array types. The multi-region capabilities enable deploying across geographically distributed regions with configurable data placement. The zone configs for data localization. The follower reads for low-latency reads. The online schema changes. The change data capture. The backup and restore. Designed by Spencer Kimball. Designed for distributed systems.