Features
Native SQL
CrateDB is easily accessible for developers via the widely known and powerful SQL language.
CrateDB’s distributed SQL query engine combines inverted indexes and columnar data structures with a modern query planner, enabling CrateDB to perform aggregations, JOINs, sub-selects, and ad-hoc queries at in-memory speed. CrateDB implements Native SQL, including joins, aggregations, indexing, sub-queries, user-defined functions and views. It also offers rich support for full-text search, geospatial queries, and nested JSON object columns, all accessible with SQL.
CrateDB’s distributed SQL query engine combines inverted indexes and columnar data structures with a modern query planner, enabling CrateDB to perform aggregations, JOINs, sub-selects, and ad-hoc queries at in-memory speed. CrateDB implements Native SQL, including joins, aggregations, indexing, sub-queries, user-defined functions and views. It also offers rich support for full-text search, geospatial queries, and nested JSON object columns, all accessible with SQL.


A major advantage of SQL is its ease of integration. CrateDB is compatible with most SQL tools, interfacing through the PostgreSQL wire protocol, JDBC, and REST.


"CrateDB allows us to do real-time dashboards on very big streaming and historic datasets in a simple way. We can scale the system easily as we grow the load and customers and have it all done with SQL."
Christopher Müller
CTO
Bitmovin
CTO
Bitmovin

Industrial IoT, Time-series, Logistics, Digital twins

"Having a standardized SQL language is a big advantage with CrateDB. That makes it very easy for people to access this data and work with it in different tools like Grafana or Tableau."
Alexander Mann
Owner Connected
Warehouse Architecture
TGW Group
Owner Connected
Warehouse Architecture
TGW Group
Additional resources
On-demand Workshop 2023
Introduction to CrateDB and its Architecture
Timestamp: 11:40–12:43
CrateDB at Carnegie Mellon University CMU Database Group
CrateDB: Distributed SQL Database Built on Top of Lucene
Timestamp: 3:30–5:10
Tutorials
February 18, 2022
We’ve created many integration-focused tutorials to help you use CrateDB with other awesome tools and libraries.