Crate

Crate is an open source, highly scalable distributed SQL database. Crate offers the scalability and performance of a modern No-SQL database with the strenght of Standard SQL. Crate’s distributed SQL query engine lets using the same syntax that already exists in applications or integrations, and have queries seamlessly executed across the crate bunch, incorporating any aggregations, if needed.

Enterprises and startups have deployed Crate clusters to power real time analytics, real time dashboards (network traffic, security events), IoT-backends (sensor data, telemetry data), ad-tech (web traffic), telecom apps (call logs, CDRs) and user-facing Web and Mobile apps.Crate is designed to support the huge scale of Web, mobile and IoT applications. Crate is horizontally scalable, means that can grow up by adding machines, without a need to re-shuffle, re-index or move data around. Its shared-nothing and masterless architecture, means that all nodes are similar, scaling from single-node to multiple nodes with a simple click.

Crate’s distributed SQL query engine takes a standard SQL query, deconstructs it and executes it in a distributed fashion on the crate cluster. It then collects the results and performs aggregations. Crate offers native full text search features and its distributed SQL query engine lets you search and aggregations in milliseconds.Crate allows the creation of partitions of any table and effectively gives separate partitions under the hood. They can be queried, moved or deleted like a single table. Crate´s schemas are flexible that allows adding columns anytime without any penalty or re-indexing requirements.

Create repositories (on fs, hdfs, s3, url) to store, manage and restore snapshots. Incremental snapshots can be made anytime and represent the state of the tables in a Crate cluster at the time the Snapshot was made, and can be restored into the cluster anytime.With drivers provided by Crate users can use almost any language to work with it.