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.