Solutions and use cases

CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

Learn how its features are applied within software solutions and application platforms in different scenarios and environments.

Overview

About time series and long-term data storage, real-time analytics, and machine learning.

Time series data:

About CrateDB for time series data analysis.

Enhance your understanding of how to use CrateDB for time series use-cases, and how to apply time series modeling and analysis procedures to your data.

What’s inside:

  • Advanced statistical analysis

  • Data visualization

  • Machine learning

  • Scientific computing

Long-term store:

About storing time series data for the long term.

Permanently keeping your raw data accessible for querying yields insightful analysis opportunities other systems can’t provide easily.

What’s inside:

  • Time-based bucketing.

  • Advanced querying.

  • Import data using Dask.

  • Optimizing storage for historic time series data.

Machine learning:

About CrateDB for machine learning applications.

Get an overview of how CrateDB provides support for different kinds of machine learning tasks, and learn how to integrate CrateDB with machine learning frameworks and tools.

What’s inside:

  • Vector store: Vector search, Hybrid search, LangChain

  • Text-to-SQL: LlamaIndex, MCP, MindsDB

  • Time series analysis: R, TensorFlow

  • MLOps and model training: MLflow, PyCaret, scikit-learn

Case studies

About solutions built with CrateDB and how others are using CrateDB successfully.

CrateDB is being developed in an open-source spirit, and closely together with its users and customers. Learn about application scenarios where CrateDB derives many foundational features from, and how others are using CrateDB to build real-time data management and analytics solutions and platforms.

Industrial big data

Learn how others are successfully using CrateDB within industrial, engineering, manufacturing, production, and logistics domains.

Use CrateDB in industrial data platforms
Real-time analytics on raw data

CrateDB provides real-time analytics on raw data. Learn how others are successfully running real-time multi-tenant data analytics applications on top of billions of records.

About CrateDB’s analytics features