CrateDB is a distributed SQL database designed for storing and analysing large amounts of structured and semi-structured information. It combines familiar SQL querying with capabilities commonly associated with document-oriented and NoSQL databases.
The database is useful for applications involving continuous data ingestion, time-series information and analytical queries over large datasets.
CrateDB supports nested objects and arrays, allowing applications to store document-like records with complex internal structures. Dynamic schema capabilities reduce the need to define every field before inserting information.
Its distributed architecture divides data and query processing across database nodes. Applications can scale storage and analytical workloads by adding resources to a cluster rather than depending on a single database server.
CrateDB uses indexing technologies to support efficient searching and aggregation. It also provides interfaces compatible with PostgreSQL clients, making it accessible to applications and administration tools already familiar with SQL databases.
Although CrateDB is fundamentally a SQL database, its flexible data model and ability to query nested objects make it relevant to document-oriented workloads.
This is free and open source software.
Key Features
- SQL querying of structured and semi-structured information.
- Nested objects and arrays within database records.
- Dynamic schema support for evolving data structures.
- Distributed query execution across database clusters.
- Automatic sharding and data replication.
- Cluster rebalancing and fault tolerance.
- Full-text search and indexing.
- Time-series data ingestion and aggregation.
- Geospatial data types and queries.
- PostgreSQL wire protocol compatibility.
- HTTP API for database operations.
- User-defined functions for extending query processing.
Website: github.com/crate/crate
Support:
Developer: Crate.io, Inc.
License: Apache License 2.0
CrateDB is written in Java. Learn Java with our recommended free books and free tutorials.
Related Software
| Document-Oriented Databases | |
|---|---|
| SurrealDB | Scalable, distributed, collaborative, document-graph database |
| Couchbase | Distributed key-value database management system |
| CouchDB | Scalable, fault-tolerant, and schema-free written in Erlang |
| ArangoDB | Native multi-model database |
| eXist-db | Database management system entirely built on XML technology |
| RethinkDB | Scalable database built for realtime applications |
| BaseX | XML database engine |
| OrientDB | Document Database supporting ACID Transactions, SQL and Native Queries |
| Aerospike | Key-Value Store and high performance real-time NoSQL (flex-schema) database |
| RavenDB | Fully-transactional NoSQL ACID database |
| FerretDB | Database proxy that offers an open-source alternative to MongoDB |
| DocumentDB | MongoDB-compatible document database engine |
| Jackrabbit | Open-source content repository for Java |
| TerminusDB | Knowledge graph and document store |
| Kinto | Minimalist JSON storage service |
| CrateDB | Distributed SQL database management |
Read our verdict in the software roundup.
| Column-Oriented Databases | |
|---|---|
| MariaDB ColumnStore | Uses a massively parallel distributed data architecture |
| DuckDB | In-process SQL OLAP database management system |
| Druid | High performance, real-time analytics database |
| Databend | Cloud data warehouse |
| ClickHouse | Real-time analytics database management system |
| InfluxDB Core | Scalable datastore for metrics, events, and real-time analytics |
| Doris | Modern data warehouse for real-time analytics |
| VictoriaMetrics | Scalable solution for monitoring and managing time series data |
| StarRocks | High-performance analytical database |
| MonetDB | High performance relational database system for analytics |
| Kudu | Distributed data storage engine |
| QuestDB | High-performance time-series database |
| Pinot | Real-time analytics platform |
| IoTDB | High-performance time-series database |
| GreptimeDB | Cloud-native database |
| CrateDB | Distributed SQL database management |
| Hyrise | Flexible platform for research into relational data management |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.