Compare CrateDB

How is CrateDB different from other databases in the market?

InfluxDB is a database specialized in time series, with excellent performance for single-node operations. But InfluxDB was not built to handle the scalability, adaptability, and high-concurrency performance required by many IoT use cases. InfluxDB was born as a single-server database; its distributed functionality is not mature, and its response to high-cardinality queries is significantly slower than CrateDB.

White Paper

CrateDB vs InfluxDB: Benchmark

Find out how both databases perform in a IoT use case under load

Unlike InfluxDB, CrateDB was designed to optimize the use of resources under multiple clients, providing millisecond responses even while performing writes. It features full horizontal scaling, a shared-nothing architecture, and automatic data rebalancing. To scale, just add more nodes to the cluster. CrateDB does the rest automatically.

  InfluxDB CrateDB
Cluster type Shared-nothing, two cluster architecture (meta nodes & data nodes) Shared-nothing
Scalability Limited Full horizontal scalability
Data replication At table level At table level
On-disk compression Type dependent LZF
Open-source MIT License Apache 2.0
Access language Flux ANSI SQL
Schemas None Dynamic
Columnar indexing No Yes
Aggregation queries Yes Yes
JOINs No Full
Full-text search No Yes (Lucene powered)

Besides, InfluxDB uses its own language, Flux. This implies that the only source available for support is the InfluxDB documentation. InfluxDB’s data model is non-relational, and it doesn’t support text search, log search, or analytics. On the contrary, CrateDB is fully accessible by SQL. And CrateDB schemas are flexible, allowing the user to add columns at any point without slowing performance or downtime.

InfluxDB can be an excellent option for single-node time-series workloads—but for real-time applications with high volumes, data variety, and heavy load, CrateDB is a better choice, due to its distributed nature, its SQL access, and its unparallel cost-efficiency. Its indexing structure is perfectly suited to handle huge volumes of time-series data together with metadata. With CrateDB, you will only need one database to handle your workload. 

Give it a try!

continue reading

Comparing databases for an industrial IoT use-case

We talk about our experience working with MongoDB, TimescaleDB and InfluxDB

White Paper

CrateDB: Technical Overview

A detailed description of CrateDB's architecture. Find out more about how CrateDB is built!


Amazon Timestream is finally released...

...and these are our first impressions