Data modelling

CrateDB provides a unified storage engine that supports different data types.

Relational data

Relational data
JSON data

JSON data
Timeseries data

Timeseries data
Geospatial data

Geospatial data
Fulltext data

Fulltext data
Vector data

Vector data
Primary key strategies

CrateDB is built for horizontal scalability and high ingestion throughput. To achieve this, auto-incrementing primary keys are not supported, and other solutions are required instead.

Primary key strategies and autogenerated sequences