CrateDB

CrateDB is a distributed SQL database for storing and analyzing very large volumes of data in real time. It dissolves the usual choice between the query language of a relational database and the scaling behavior of a NoSQL store.

Clients connect over the PostgreSQL wire protocol or an HTTP API, so existing SQL tools and drivers work unchanged. A distributed execution engine parallelizes each query across the whole cluster, and modest clusters ingest tens of thousands of records per second.

The database absorbs several jobs that usually need separate systems.

• Dynamic schemas: tables accept new columns and queryable objects, adding document-oriented behavior on top of relational SQL.
• Time series and search: time series data, real-time full-text search and geospatial types with their own search capabilities.
• Cluster automation: auto-partitioning, auto-sharding, auto-replication, self-healing and auto-rebalancing.
• User-defined functions: extend the SQL surface with functions of your own.
• Admin UI: a browser console for running SQL and watching the cluster.

CrateDB suits containers and scales horizontally on ephemeral virtual machines with no shared state, whether on Kubernetes, AWS or Azure. The same engine runs on a personal computer, across multi-region hybrid clouds and out at the edge. An official Docker image starts a single node in one command, and Crate.io, which maintains the project, also offers a fully managed database as a service.