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.
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
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
Product documentation
SQL Compatibility
SQL Standard Compliance
SQL Statements
General SQL
Additional resources
CrateDB at Carnegie Mellon University CMU Database Group
CrateDB: Distributed SQL Database Built on Top of Lucene
Timestamp: 3:30–5:10
Tutorials
Overview of CrateDB integration tutorials
February 18, 2022
We’ve created many integration-focused tutorials to help you use CrateDB with other awesome tools and libraries.
