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…
Philip O'Toole
Software engineering, distributed systems, databases, and the teams that build them
Philip O'Toole
Software engineering, distributed systems, databases, and the teams that build them
Tag database
rqlite 10.5.1 to 10.6.0: Numeric Error Codes, Node Promotion, and CDC Fixes
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 10.3.1 to 10.4.0: Cluster Integrity, Streaming Backups, and CDC 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,…
rqlite v10.3.0 – features, upgrades, and bug fixes
rqlite is a lightweight, open-source, fault-tolerant relational database built on SQLite and Raft. Version 10.3.0 has been released and includes some updates to the web console, upgraded SQLite, and other bug fixes and improvements. The headline fix in this release, however, comes…
From 18 months to 6: High-velocity database engineering
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 v10.2: Improving the web console
rqlite is a lightweight, open-source, distributed relational database built on SQLite and Raft. Version 10.2.0 has been released with more improvements to the built-in web console and mutual TLS support.
rqlite reaches 1 million Docker downloads
rqlite is a lightweight, open-source, fault-tolerant database built on SQLite and Raft. It’s reached a new milestone this week – 1 million Docker downloads. Thanks to the entire rqlite community for their support and engagement with rqlite.
rqlite v10.1: Schema management via the Web Console
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…
Taking control of the SQLite WAL
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 10.0: Better clustering and better management
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 9.3.1 to 9.3.4: Parser Updates, Static Analysis Fixes, and Non-Root Docker Images
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…
Balancing SQLite’s WAL, SYNCHRONOUS=OFF, and fsync for fast rqlite recovery
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 reaches 17,000 stars on GitHub
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. It has reached a new milestone in the open-source community by surpassing 17,000 stars on GitHub. Thanks to everyone for the ongoing support.
rqlite 9.0: Real-time Change Data Capture for Distributed SQLite
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…
On the way to rqlite 9.0
rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Development for the 9.0 release has started, and should be an important release. The main goals for 9.0 include: Change Data Capture…
Consistency Over Availability: How rqlite handles the CAP Theorem
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. When it comes to distributed systems the CAP theorem is an essential concept. It states that it’s impossible for a distributed database to simultaneously provide…
rqlite 8.38.0 to 8.42.0: Leader Stepdown, Google Cloud Backups, and More
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…
New JDBC driver for rqlite
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. Thanks to Jesus Zazueta there is a new JDBC driver for rqlite. Specifically it’s a Type 4 driver, which means it communicates directly with the…
rqlite Helm charts now on Artifact Hub
Artifact Hub is a web-based application that enables finding, installing, and publishing Cloud Native packages and configurations. The official rqlite Helm charts have now been published there. Many thanks to Jason Tackaberry for putting this together.
How rqlite is tested
rqlite is a lightweight, open-source, distributed relational database written in Go, and built on SQLite and Raft. With its origins dating back to 2014, its design has always prioritized reliability, and quality. The robustness of rqlite is also a testament…
rqlite 8.34.0 to 8.36.0: New Features and Enhancements
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…
New Configuration Guide for rqlite
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. I’ve added a new Configuration Guide for rqlite, which has been regularly requested. rqlite has many options and although the…
Faster Reads, Same Guarantees: Linearizable Consistency in rqlite 8.32
rqlite is a lightweight, open-source, distributed relational database. It’s written in Go, built on the Raft consensus algorithm, and uses SQLite as its storage engine. With release 8.32, rqlite now supports fast, reliable, Linearizable reads—delivering strong consistency guarantees without the…
rqlite 8.31.0: Improved support for BLOB data
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 8.30.0: Introducing Automatic Database Optimization
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.