crate

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 Postgre

What is crate?

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.

Overview of crate

What it is

CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of data in real-time. It is PostgreSQL-compatible and based on Lucene. It offers the benefits of an SQL database along with the scalability and flexibility typically associated with NoSQL databases.

Key features

  • Use standard SQL via the PostgreSQL wire protocol or an HTTP API.
  • Dynamic table schemas and queryable objects provide document-oriented features in addition to relational features.
  • Support for time-series data, real-time full-text search, and geospatial data types and search capabilities.
  • Horizontally scalable, highly available, and fault-tolerant clusters that run well in virtualized and containerized environments.
  • Extremely fast distributed query execution.
  • Auto-partitioning, auto-sharding, and auto-replication.
  • User-defined functions (UDFs) can extend functionality.

Use cases

CrateDB is designed for storing and analyzing massive amounts of data in near real-time. It is well suited for time-series data, real-time full-text search, and geospatial applications. It can be deployed on any network from personal computers to multi-region hybrid clouds and the edge, and works well in containerized environments.

Getting started

Run CrateDB via the official Docker image:docker run --publish 4200:4200 --publish 5432:5432 --env CRATE_HEAP_SIZE=1g crate '-Cdiscovery.type=single-node'For other installation options, see the repository README.

License and pricing

CrateDB is open source under the Apache License 2.0.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/cratecrate.svg)](https://yunodb.com/tools/cratecrate?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/cratecrate?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/cratecrate.svg" alt="Featured on YunoDB" height="20"></a>