Repository files navigation

rqlite is afeature-rich,rock-solid, fault-tolerant, distributed relational database built onSQLite. It'slightweight,developer-friendly, andexceptionally easy to operate, offering effortless installation and deployment.

Use rqlite to reliably store your most important data, ensuring it's always available to your applications -- thinketcd, but with relational modeling available. Whether you're deployingresilient services in the cloud orreliable applications at the edge, rqlite provides a robust solution for critical data.

Website ·Slack

Check out the full Quick Start guide

1. Run a rqlite node:

docker run -p 4001:4001 rqlite/rqlite

2. Create a table and insert a row:

curl -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\")"]'

3. Query the data:

curl -G'localhost:4001/db/query?pretty' --data-urlencode'q=SELECT * FROM foo'

Learn how to form a multi-node cluster in seconds. and dive into theDeveloper Guide.

Core functionality

• Relational: Full SQL support via SQLite, includingFull-text search,JSON support, and more.
• Extensible:Load SQLite extensions to add capabilities likeVector Search andCrypto.
• Atomic Requests: Execute multiple SQL statements atomically within a single API request.
• Change Data Capture:Stream database changes to an external system.

Easy operations

• 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: Automaticclustering viaKubernetes,Docker Compose, Consul, etcd, or DNS.
• Effortless Backups: Hotbackups, includingautomatic backups to AWS S3, MinIO, and Google Cloud, as well asrestore directly from SQLite andCloud-based storage.

Developer experience

• Simple APIs: Easy-to-useHTTP API. ACLI andclient libraries are also available.
• Robust Security:End-to-end encryption with TLS and rich authentication/authorization controls.
• Tunable Consistency: Customizeread consistency anddurability to match your application's needs.

• Join the rqlite Slack channel
• Sign up for Office Hours

Common pronunciations of rqlite include "R Q lite" and "ree-qwell-lite".