Twelve years of distributed SQLite
In September 2014 I published a short post announcing rqlite. The idea was simple: take SQLite, put a Raft log in front of it, and replicate every write to a cluster so that the loss of a node did not…
Software engineering, distributed systems, databases, and the teams that build them
Software engineering, distributed systems, databases, and the teams that build them
In September 2014 I published a short post announcing rqlite. The idea was simple: take SQLite, put a Raft log in front of it, and replicate every write to a cluster so that the loss of a node did not…
rqlite is a lightweight, open-source, fault-tolerant relational database built on SQLite and the Raft consensus protocol. Versions 10.5.1 through 10.6.0 focus on four core themes: richer error reporting in the API, changing a node’s voting status at runtime, a security…
rqlite is a lightweight, open-source, distributed relational database built on SQLite and the Raft consensus protocol. Versions 10.3.1 through 10.4.0 focus on four core themes: safeguarding cluster consistency under local fault conditions, overhauling how database backups stream over the network,…
I recently appeared on the Bug Bash podcast to talk about rqlite, software testing, and the impact of Agentic coding. You check out the audio podcast on Apple Podcasts, and the video on YouTube.
rqlite is a lightweight, open-source, distributed relational database built on SQLite and Raft. Version 10.1.0 has been released with improvements to the built-in web console. The web console now support directly examining the schema of your database tables, and basic…
rqlite is a lightweight, open-source, fault-tolerant relational database built on SQLite and Raft. Version 10 is out now. rqlite uses SQLite as its storage engine and has a particular relationship with the SQLite Write-Ahead Log (WAL). SQLite, left to itself, manages its…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go, employs Raft for distributed consensus, and uses SQLite as its storage engine. rqlite v10.0 has been released and introduces improved cluster and management features, including a new…
rqlite is a lightweight, open-source, distributed relational database built on SQLite and Raft. Versions 9.3.5 through 9.3.10 focus on internal correctness and operational robustness, particularly around Raft snapshotting, WAL handling, and testing. These releases also include improvements to logging, the…
rqlite is a lightweight, open-source, distributed relational database built on SQLite and Raft. Versions 9.3.1 through 9.3.4 deliver a set of targeted fixes and internal improvements, most of them aimed at code quality, security posture, and correctness. The only user-facing…
rqlite is a lightweight, user-friendly, distributed relational database. It’s written in Go, employs Raft for distributed consensus, and uses SQLite as its storage engine. The newly released rqlite 9.2 introduces a major improvement to startup performance – nodes can now resume from where they…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go, employs Raft for distributed consensus, and uses SQLite as its storage engine. rqlite 9.0 introduces Change Data Capture (CDC), enabling you to stream the changes occurring to the…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. Recent versions—8.38.0 through 8.42.0—introduce several notable improvements, including Google Cloud Storage support, new HTTP APIs for cluster control, and improvements…
rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine and Raft for consensus. Ten years ago, I tagged the first release of rqlite—a project I started to explore distributed consensus, to learn Go, and…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. Version 8.37.0 adds automatic reloading of X.509 certificates and keys. rqlite now monitors the relevant files and reloads them without…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. rqlite has received several important updates in recent weeks. These updates, spanning versions 8.34.0 through 8.36.0, introduce new features and…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. Release 8.31.0 is out now and adds support for inserting BLOB data as Parameterized Values. This should make it even…
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. Release 8.30.0 is out now and adds support for Automatic Optimize.
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. Stephen Blum, CTO at PubNub has produced an informative video on rqlite. In it Stephen gives an overview of deploying rqlite,…
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. Release v8.29.0 bakes more SQLite extensions into the Docker image, as well as improving extension management generally.
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. With the release of rqlite 8.28.3, working with SQLite extensions in a Docker environment has become even more straightforward.
rqlite is a lightweight, open-source, distributed relational database written in Go. It is built on the Raft consensus protocol and uses SQLite as its storage engine. Release v8.27.0 introduces the capability to load SQLite extensions at startup, significantly expanding the…
rqlite is a lightweight, open-source, distributed relational database written in Go. It is built on the Raft consensus protocol and uses SQLite as its storage engine. Development of 9.0 has begun and aims to reduce disk usage by approximately 50%.…
rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine. Release v8.24.9 is the first release that comes with multi-platform Docker support. You can now pull a Docker image for 386, ARM, and…
rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine. Release v8.24.0 adds the ability to automatically upload point-in-time backups to AWS S3 and S3-compatible storage systems.
Did you know that SQLite contains a full text search engine? The SQLite FTS4 and FTS5 Extensions allow you to perform full-text searches on documents loaded into SQLite. And since rqlite uses SQLite as its database engine, rqlite makes it…