The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort.
go get github.com/rqlite/rqlite
rqlite is a feature-rich, rock-solid, fault-tolerant, distributed relational database built on SQLite. It's lightweight, developer-friendly, and exceptionally 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 -- think etcd, but with relational modeling available. Whether you're deploying resilient services in the cloud or reliable applications at the edge, rqlite provides a robust solution for critical data.
Quick Start
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 the Developer Guide.
Key features
Core functionality
- 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 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: 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.
Developer experience
- 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.
More questions?
Pronunciation
Common pronunciations of rqlite include "R Q lite" and "ree-qwell-lite".