crate/crate

What it solves

CrateDB is a distributed SQL database designed to store and analyze massive amounts of data in real-time. It bridges the gap between the relational power of SQL and the scalability and flexibility of NoSQL databases, allowing users to ingest tens of thousands of records per second and perform ad-hoc queries across a cluster.

How it works

CrateDB uses a distributed query execution engine that parallelizes workloads across the entire cluster. It is built for containerization and horizontal scaling using ephemeral virtual machines (like Kubernetes) with a shared-nothing architecture. It supports standard SQL via the PostgreSQL wire protocol or an HTTP API, and features auto-partitioning, auto-sharding, and auto-replication to ensure high availability and fault tolerance.

Who it’s for

It is designed for developers and data engineers who need a highly scalable, fault-tolerant database for real-time data analysis, time-series data, full-text search, and geospatial data.

Highlights

• Standard SQL Support: Access data via PostgreSQL wire protocol or HTTP API.
• Hybrid Schema: Combines relational features with dynamic table schemas and queryable objects for document-oriented flexibility.
• CrateDB Admin UI: Includes a built-in web interface for database administration and SQL console.
• Specialized Data Types: Native support for time-series, geospatial data, and real-time full-text search.
• Self-Healing: Features auto-rebalancing and self-healing capabilities for cluster stability.