OSS Alternative - Discover Top Open Source Alternatives to Popular Software

crate/crate

CrateDB is a distributed SQL database combining the benefits of SQL with NoSQL scalability for real-time data storage and analysis.

Core Features

Uses standard SQL via the PostgreSQL wire protocol or an HTTP API.

Dynamic table schemas and queryable objects provide document-oriented features alongside relational SQL.

Supports time-series data, real-time full-text search, and geospatial data types and search capabilities.

Horizontally scalable, highly available, and fault-tolerant clusters, optimized for virtualized and containerized environments.

Extremely fast distributed query execution with auto-partitioning, auto-sharding, and auto-replication.

Quick Start

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

Detailed Introduction

CrateDB is a powerful distributed SQL database designed for handling and analyzing massive datasets in near real-time. It uniquely blends the familiarity and power of standard SQL with the horizontal scalability and flexibility typically found in NoSQL systems. Built on Lucene and PostgreSQL-compatible, CrateDB excels in environments requiring high-speed data ingestion, complex ad-hoc queries, and support for diverse data types like time-series, full-text, and geospatial data. Its architecture is optimized for containerized and cloud deployments, offering self-healing and auto-rebalancing capabilities for robust, fault-tolerant operations across various infrastructures.