rqlite

The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort.

What is rqlite?

The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort.

Overview of rqlite

What it is

rqlite is a lightweight, fault-tolerant distributed relational database built on SQLite. It is designed to keep data highly available with minimal effort. The project is open source under the MIT license.

Key features

  • Relational: Full SQL support via SQLite, including Full-text search, JSON support, and more.
  • Extensible: Load SQLite extensions to add capabilities like Vector Search and Crypto.
  • Atomic Requests: Execute multiple SQL statements atomically within a single API request.
  • Change Data Capture: Stream database changes to an external system.
  • Easy Deployment: A single binary with no external dependencies. Up and running in seconds.
  • High Availability: Fully replicated database provides fault-tolerance. Outage of a node doesn't impact the cluster.
  • Dynamic Clustering: Automatic clustering via Kubernetes, Docker Compose, Consul, etcd, or DNS.
  • Effortless Backups: Hot backups, including automatic backups to AWS S3, MinIO, and Google Cloud, as well as restore directly from SQLite and Cloud-based storage.
  • Simple APIs: Easy-to-use HTTP API. A built-in console app, CLI and client libraries are also available.
  • Robust Security: End-to-end encryption with TLS and rich authentication/authorization controls.
  • Tunable Consistency: Customize read consistency and durability to match your application's needs.

Use cases

Use rqlite to reliably store your most important data, ensuring it is always available to your applications. It is suitable for deploying resilient services in the cloud or reliable applications at the edge.

Getting started

Run a rqlite node with Docker:bashdocker run -p 4001:4001 rqlite/rqliteCreate a table and insert a row:bashcurl -XPOST 'localhost:4001/db/execute?pretty' -H 'Content-Type: application/json' -d '[ 'CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY, name TEXT)', 'INSERT INTO foo(id, name) VALUES(1, 'fiona')']'Query the data:bashcurl -G 'localhost:4001/db/query?pretty' --data-urlencode 'q=SELECT * FROM foo'

License and pricing

Licensed under MIT. No pricing information is provided as it is open source.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/rqliterqlite.svg)](https://yunodb.com/tools/rqliterqlite?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/rqliterqlite?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/rqliterqlite.svg" alt="Featured on YunoDB" height="20"></a>