All Features

All features of CrateDB at a glance.

Functional

• SQL
• Connectivity
• Document Store
• Relational / JOINs
• Search: FTS, Geo, Vector, Hybrid
• BLOB Store

CrateDB combines the power of Lucene with the advantages of industry-standard SQL.

Operational

• Clustering
• Snapshots
• Cloud Native
• Storage Layer
• Hybrid Index

CrateDB scales horizontally using a shared-nothing architecture, inherited from Elasticsearch.

Advanced

• Advanced Querying
• Generated Columns
• Server-Side Cursors
• Foreign Data Wrapper
• User-Defined Functions
• Cross-Cluster Replication

Advanced features supporting daily data operations, all based on standard SQL.

Connect and Integrate

Connect to CrateDB using traditional database drivers, and integrate CrateDB with popular 3rd-party applications in open-source and proprietary software landscapes.

Connectivity

Connect to your CrateDB cluster using drivers, frameworks, and adapters.

What’s inside: Connectivity and integration options with database drivers and applications, libraries, and frameworks.

About connection options with CrateDB

Import and Export

Import data into and export data from your CrateDB cluster.

What’s inside: A variety of options to connect and integrate with 3rd-party ETL applications.

About time series data import and export

Highlights

Important fundamental features of CrateDB, and how they are applied within software solutions and application platforms in different scenarios and environments.

Document Store

Learn about CrateDB’s OBJECT data type, how to efficiently store JSON or other structured data, also nested, and how to query this data with ease, fully indexed thus performant from the start, optionally using relational joins.

What’s inside: CrateDB can do the same like Lotus Notes / Domino, CouchDB, MongoDB, and PostgreSQL’s JSON data type.

About CrateDB’s OBJECT data type

Full-Text Search

Learn about CrateDB’s Okapi BM25 implementation, how to set up your database for full-text search, and how to query text data efficiently, to make sense of large volumes of unstructured information.

What’s inside: Like Elasticsearch and Solr, CrateDB is based on Lucene, the premier industry-grade full-text search engine library.

About CrateDB’s full-text search capabilities

Quotes

When using CrateDB, a project that got started around the same time, it’s like you’ve stumbled into an alternative reality where Elastic is a proper database.

-– Henrik Ingo, Nyrkiö Oy, independent database consultant, MongoDB

CrateDB enables use cases we couldn’t satisfy with other database systems, also with databases which are even stronger focused on the time series domain.

CrateDB is not your normal database!

– Daniel Hölbling-Inzko, Director of Engineering Analytics, Bitmovin