distributed relational database on SQLite
rqlite is a lightweight, fault-tolerant distributed relational database that replicates SQLite using Raft consensus and exposes an HTTP API.
Solves the same problem with a different architecture or at a different layer. Expect to rewrite the integration.
Choose when you need a production-scale distributed SQL database with PostgreSQL compatibility, accepting much heavier operational overhead.
CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
Choose when you want serverless Postgres with autoscaling and branching rather than a small, self-contained SQLite cluster.
Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.
Choose when you already run PostgreSQL and need distributed sharding as an extension instead of a standalone SQLite-based system.
Distributed PostgreSQL as an extension
Choose when you need a cloud-native distributed SQL database with PostgreSQL compatibility and stronger consistency, at the cost of a heavier deployment.
YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
Choose when you prefer SQLite distribution via object storage instead of Raft-based replication.
Open source distributed database built on SQLite and backed by distributed file systems and object storage
Choose when you need an embeddable C library for replicated SQLite rather than a standalone HTTP server.
Embeddable, replicated and fault-tolerant SQL engine.
These projects were analysed and named rqlite among their alternatives. The relationship is not symmetric — how rqlite rates them is a separate judgement, made when rqlite is analysed in its own right.
calls rqlite “Choose for a lightweight distributed SQLite cluster if you need simple relational HA.”
A scalable, distributed, collaborative, document-graph database, for the realtime web
calls rqlite “choose for a lightweight fault-tolerant SQLite-layer database with minimal footprint.”
🥑 ArangoDB is a native multi-model database with flexible data models for documents, graphs, and key-values. Build high performance applications using a convenient SQL-like query language or JavaScript extensions.
calls rqlite “Choose when you want SQLite semantics behind a Raft cluster for HA, accepting network hops and SQL over Datalog.”
A simple, fast and versatile Datalog database
calls rqlite “choose when you need a lightweight, fault-tolerant SQL database built on SQLite for minimal footprints.”
CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
calls rqlite “Choose when you need a lightweight, easy-to-deploy distributed SQLite for small datasets and high availability, not massive sharding.”
Distributed PostgreSQL as an extension
calls rqlite “Choose if you need a lightweight, simple distributed SQL database and can live with SQLite limitations.”
YugabyteDB - the cloud native distributed SQL database for mission-critical applications.