What is CrateDB?
CrateDB is an open-source SQL database with a groundbreaking distributed design. It uses SQL to process any type of data, structured or unstructured, and performs distributed SQL queries at real-time speed, even JOINs and aggregates. CrateDB makes scaling simple, enabling customers to store and query machine data effortlessly. Customers have reported CrateDB ingesting millions of data points per second, while also querying terabytes of data in real-time - 20x faster than their previous database and on 75 less database hardware Crate.io, the developers of CrateDB, have created a global multi-model database that enables companies to access data insights at scale. The flexible, distributed database solution combines the performance of NoSQL with the power and simplicity of standard SQL. Optimized for large data volumes with high compute and data versatility requirements, CrateDB runs in the cloud, on the edge, and on-premise. Crate.io was named as an Honorable Mention in the 2021 Gartner Magic Quadrant for Cloud Database Management Systems
Highlights
- ocesses any type of data, structured or unstructured, using SQL
- Performs distributed SQL queries at real-time speed, even complex operations like JOINs and aggregates
- Enables scaling with effortless data ingestion and querying of large data volumes
- Offers a flexible, distributed database solution that combines the performance of NoSQL with the simplicity of SQL
- Runs in the cloud, on the edge, and on-premise to accommodate diverse deployment requirements
Features
Clustering
IOT Analytics
Time Series
Geospatial analysis
Full-Text Search
MQTT
Real-time analytics