CrateDB offers a standards-based SQL implementation focused on achieving ANSI SQL compatibility, making it easily accessible for developers via the well-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, common table expressions, 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 implements the PostgreSQL Wire Protocol, ensuring compatibility with most SQL tools using the PostgreSQL drivers. It provides two primary client interfaces: one via the PostgreSQL Wire Protocol and another through an HTTP endpoint. Designed for SQL-enabled ETL, reporting, and development frameworks, CrateDB offers flexibility to integrate with various data stack tools, preventing vendor lock-in and promoting adaptability.
"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
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
