CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of data in real-time.
CrateDB offers the benefits of an SQL database and the scalability and flexibility typically associated with NoSQL databases. Modest CrateDB clusters can ingest tens of thousands of records per second without breaking a sweat. You can run ad-hoc queries using standard SQL. CrateDB's blazing-fast distributed query execution engine parallelizes query workloads across the whole cluster.
CrateDB is well suited to containerization, can be scaled horizontally using ephemeral virtual machines (e.g., Kubernetes, AWS, and Azure) with no shared state. You can deploy and run CrateDB on any sort of network — from personal computers to multi-region hybrid clouds and the edge.
- 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 the relational features of SQL.
- Support for time-series data, real-time full-text search, geospatial data types and search capabilities.
- Horizontally scalable, highly available and fault-tolerant clusters that run very well in virtualized and containerized environments.
- Extremely fast distributed query execution.
- Auto-partitioning, auto-sharding, and auto-replication.
- Self-healing and auto-rebalancing.
- User-defined functions (UDFs) can be used to extend the functionality of CrateDB.
CrateDB provides an Admin UI:
The fastest way to try CrateDB out is by running:
sh$ bash -c "$(curl -L try.crate.io)"
Or spin up the official Docker image:
sh$ docker run --publish 4200:4200 --publish 5432:5432 crate -Cdiscovery.type=single-node
Visit the installation documentation to see all the available download and install options.
Once you're up and running, head over to the introductory docs. To interact with CrateDB, you can use the Admin UI sql console or the CrateDB shell CLI tool. Alternatively, review the list of recommended clients and tools that work with CrateDB.
This project is primarily maintained by Crate.io, but we welcome community contributions!
Looking for more help?