Repository files navigation

Help us improve CrateDB by taking our User Survey!

CrateDB is a distributed SQL database that makes it simple to store and analyzemassive amounts of data in real-time.

CrateDB offers thebenefits of an SQL databaseand the scalability andflexibility typically associated with NoSQL databases. Modest CrateDB clusterscan ingest tens of thousands of records per second without breaking asweat. You can run ad-hoc queries usingstandard SQL. CrateDB's blazing-fastdistributed query execution engine parallelizes query workloads across thewhole cluster.

CrateDB is well suited tocontainerization, can bescaled horizontallyusing ephemeral virtual machines (e.g.,Kubernetes,AWS, andAzure)withno shared state. You can deploy and run CrateDB on any sort of network— from personal computers tomulti-region hybrid clouds and the edge.

• Usestandard SQL via thePostgreSQL wire protocol or anHTTP API.
• Dynamic table schemas and queryable objects providedocument-oriented features in addition to the relational features of SQL.
• Support for time-series data, real-time full-text search, geospatial datatypes and search capabilities.
• Horizontally scalable, highly available and fault-tolerant clusters that runvery 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 anAdmin UI:

Run CrateDB via the officialDocker Image:

sh$docker run --publish 4200:4200 --publish 5432:5432 --env CRATE_HEAP_SIZE=1g crate -Cdiscovery.type=single-node

Or visit theinstallation documentation to see all the available download andinstall options.

Once you're up and running, head over to theintroductory docs. To interactwith CrateDB, you can use the Admin UIsql console or theCrateDB shellCLI tool. Alternatively, review the list of recommendedclients and toolsthat work with CrateDB.

For container-specific documentation, check out theCrateDB on Docker how-toguide or theCrateDB on Kubernetes how-to guide.

This project is primarily maintained byCrate.io, but we welcome communitycontributions!

See thedeveloper docs and thecontribution docs for more information.

The CrateDB team and community take security bugs seriously. We appreciate yourefforts toresponsibly disclose your findings, and will make every effort toacknowledge your contributions.

If you think you discovered a security flaw, please follow the guidelines atSECURITY.md.

Looking for more help?

• Try one of ourbeginner tutorials,how-to guides, or consult thereference manual.
• Check out oursupport channels.
• Crate.io also offersCrateDB Cloud, a fully-managedCrateDB Databaseas a Service (DBaaS). TheCrateDB Cloud Tutorials will get you started.