CrateDB System Properties

CrateDB is an open-source distributed SQL database that spreads data and processing across an elastic cluster of identical, shared-nothing nodes.

Performance​

• Run ad-hoc queries​ across 100s of billions of records in < 1 second​

• Use columnar storage for hyper-fast aggregations​

• With fully distributed query engine on top of Apache Lucene®​

Ease of Use and Flexibility​

• Standard SQL and PostgreSQL Wire Protocol for easy onboarding and great tool compatibility​

• Analyze relational, object, time-series, geo and full-text data all in one system​

Scalability and Reliability​

• Scale from a single node to analyzing petabytes of data across hundreds of nodes in a cluster​

• Built-in high availability and automatic failover​

• Fully-managed Cloud, Hybrid and On-Premises (OSS)​

Try CrateDB Cloud for free

Download CrateDB

Read the CrateDB Technical Overview

CrateDB is typically used in operational analytics applications.

In those scenarios, CrateDB competitive advantages include:

• Easier to adopt and integrate than proprietary NoSQL DB interfaces - SQL!

• Query versatility - SQL joins, aggregations, special indexing for time series, text search, geospatial, user-defined functions for AI/ML

• Simple scaling and high availability - CrateDB automates partitioning, sharding, replication, indexing.

• Real-time performance - ingests and queries data in real-time via parallel processing, in-memory columnar indexes.

• Dynamic schemas - new columns and nested object (JSON) attributes are added to the schema automatically as they are inserted.

CrateDB is ideal for integrating and analyzing streams of data in order to monitor, predict and optimize the behavior of smart systems in real time.

Popular use cases include:

• IoT & Sensors: millions of IoT data points per second with CrateDB (Gantner Instruments)

• Time Series: perfect for monitoring how data changes over time and why and where (ALPLA)

• Geospatial Tracking: powerful geospatial indexing to build vehicle tracking and other GIS applications (Thomas Concrete Group)

• Cybersecurity: run real-time analytics on streams of network, IT event, and log data (Bitmovin)

CrateDB customers include Bitmovin, ALPLA, Gantner Instruments, SPGo!, TGW Logistics Group, Thomas Concrete Group, ABB, and more.

Download an e-book to learn how our customers harnessed the full value of their operational data with CrateDB.

• The CrateDB open source project was started in 2013

• Honorable Mention in 2021 Gartner® Magic Quadrant™ Cloud Database Management Systems​

• CrateDB was the winner of the 2021 IoT Evolution: Industrial IoT Product of the Year Award

• As of 2023...

  • CrateDB has been downloaded over 2 million times since its introduction in 2014

  • Crate.io has offices in Redwood City, Berlin, Vienna, and Dornbirn, Austria. 

• CrateDB Cloud The efficiency & range of CrateDB in the Cloud

• CrateDB Edge brings the scale, availability, and convenience of a managed CrateDB cluster wherever your data is — including remote and tions

• CrateDB on-premises is open source and free to use under the Apache 2 license.

Learn about CrateDB pricing