crate
crate copied to clipboard
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.
.. image:: docs/_static/crate-logo.svg :alt: CrateDB :target: https://crate.io/
.. image:: https://github.com/crate/crate/workflows/CrateDB%20SQL/badge.svg?branch=master :target: https://github.com/crate/crate/actions?query=workflow%3A%22CrateDB+SQL%22
.. image:: https://img.shields.io/badge/docs-latest-brightgreen.svg :target: https://crate.io/docs/en/latest/
.. image:: https://img.shields.io/badge/container-docker-green.svg :target: https://hub.docker.com/_/crate/
|
About
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
_.
Features
-
Use
standard SQL
_ via thePostgreSQL wire protocol
_ or anHTTP API
_. -
Dynamic table schemas and queryable objects provide document-oriented features in addition to the relational features of SQL.
-
Support for time-series data, realtime full-text search, geospatial data types and search capabilities.
-
Horizontally scalable, highly available and fault tolerant clusters that run very well in virtualized and containerised environments.
-
Extremely fast distributed query execution.
-
Auto-partitioning, auto-sharding, and auto-replication.
-
Self-healing and auto-rebalancing.
Screenshots
CrateDB provides an Admin UI
_:
.. image:: crate-admin.gif :alt: Screenshots of the CrateDB Admin UI
Try CrateDB
The fastest way to try CrateDB out is by running:
.. code-block:: console
sh$ bash -c "$(curl -L try.crate.io)"
Or spin up the official Docker image
_:
.. code-block:: console
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.
For container-specific documentation, check out the CrateDB on Docker how-to guide
_ or the CrateDB on Kubernetes how-to guide
_.
Contributing
This project is primarily maintained by Crate.io
_, but we welcome community
contributions!
See the developer docs
_ and the contribution docs
_ for more information.
Help
Looking for more help?
-
Try one of our
beginner tutorials
,how-to guides
, or consult thereference manual
_. -
Check out our
support channels
_. -
Crate.io
_ also offersCrateDB Cloud
, a fully-managed CrateDB Database as a Service (DBaaS). TheCrateDB Cloud Tutorials
will get you started.
.. _Admin UI: https://crate.io/docs/crate/admin-ui/ .. _AWS: https://crate.io/docs/crate/howtos/en/latest/deployment/cloud/aws/index.html .. _Azure: https://crate.io/docs/crate/howtos/en/latest/deployment/cloud/azure.html .. _beginner tutorials: https://crate.io/docs/crate/tutorials/ .. _benefits: https://crate.io/cratedb-comparison/ .. _clients and tools: https://crate.io/docs/crate/clients-tools/en/latest/ .. _containerization: https://crate.io/docs/crate/howtos/en/latest/deployment/containers/docker.html .. _contribution docs: CONTRIBUTING.rst .. _Crate.io: https://crate.io/ .. _CrateDB clients and tools: https://crate.io/docs/crate/clients-tools/ .. _CrateDB Cloud Tutorials: https://crate.io/docs/cloud/ .. _CrateDB Cloud: https://crate.io/products/cratedb-cloud/ .. _CrateDB on Docker how-to guide: https://crate.io/docs/crate/howtos/en/latest/deployment/containers/docker.html .. _CrateDB on Kubernetes how-to guide: https://crate.io/docs/crate/howtos/en/latest/deployment/containers/kubernetes.html .. _CrateDB shell: https://crate.io/docs/crate/crash/ .. _developer docs: devs/docs/index.rst .. Docker image: https://hub.docker.com//crate/ .. _document-oriented: https://en.wikipedia.org/wiki/Document-oriented_database .. _Dynamic table schemas: https://crate.io/docs/crate/reference/en/master/general/ddl/column-policy.html#column-policy .. _fulltext search: https://crate.io/docs/crate/reference/en/latest/general/dql/fulltext.html .. _geospatial features: https://crate.io/docs/crate/reference/en/master/general/dql/geo.html .. _how-to guides: https://crate.io/docs/crate/howtos/ .. _HTTP API: https://crate.io/docs/crate/reference/en/latest/interfaces/http.html .. _installation documentation: https://crate.io/docs/crate/tutorials/en/latest/install.html .. _introductory docs: https://crate.io/docs/crate/tutorials/ .. _Kubernetes: https://crate.io/docs/crate/howtos/en/latest/deployment/containers/kubernetes.html .. _multi-region hybrid clouds and the edge: https://crate.io/products/cratedb-edge/ .. _no shared state: https://en.wikipedia.org/wiki/Shared-nothing_architecture .. _PostgreSQL wire protocol: https://crate.io/docs/crate/reference/en/latest/interfaces/postgres.html .. _queryable objects: https://crate.io/docs/crate/reference/en/master/general/dql/selects.html#container-data-types .. _reference manual: https://crate.io/docs/crate/reference/ .. _relational: https://en.wikipedia.org/wiki/Relational_model .. _scaled horizontally: https://stackoverflow.com/questions/11707879/difference-between-scaling-horizontally-and-vertically-for-databases .. _standard SQL: https://crate.io/docs/crate/reference/en/latest/sql/index.html .. _support channels: https://crate.io/support/ .. _time-series data: https://crate.io/docs/crate/tutorials/en/latest/normalize-intervals.html .. _sql console: https://crate.io/docs/crate/admin-ui/en/latest/console.html#sql-console