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.
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 open-source
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…
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…
Native Linux packages for rqlite
rqlite is a lightweight, open-source, distributed relational database built on SQLite and Raft. Starting with v9.4.1 rqlite now ships native Linux packages (.deb and .rpm) for easier installation and upgrades. Both amd64 and arm64 packages are available.
The source code was the moat. But not anymore
Last week I started using some of the new coding agents properly. Not in a careful, experimental way, but properly — for three days on rqlite. Claude Code. Copilot CLI. Tools I had yet to fully integrate into how I…
rqlite 9.3.5 to 9.3.10: Snapshot Robustness, WAL Handling, and Shell Improvements
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 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…
rqlite images now available on GitHub Container Registry
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. rqlite container images are now mirrored to GitHub Container Registry (GHCR). Images on Docker Hub and GHCR carry the same tags and digests; you can…
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.
Tokens & Tactics: Scaling Yourself Horizontally with AI
I was recently interviewed by Noah Brier for his BRXND Tokens & Tactics AI newsletter. Noah and I used to work together a few years ago at Percolate so it was good to connect again. You can check out the…
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…
My development team costs $41.73 a month
Two years ago, I appeared on Contributor, a podcast hosted by Eric Anderson of Scale Venture Partners. I was there to talk about rqlite, the open-source database I maintain.
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…
The Developer’s Manifesto for the Age of LLMs
We built the old software systems by hand. Line by line. Module by module. That era is ending. Something profound is happening. For the first time in the history of software, we are not the only entities capable of understanding…
rqlite development: the Agents are here
rqlite is a lightweight, open-source, distributed relational database written in Go. It uses SQLite as its storage engine and Raft for consensus. I’ve been developing rqlite for about ten years, and until recently, the workflow hadn’t changed much. I write the code. Others contribute here…
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 turns 10: Observations from a decade building Distributed Systems
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…
Gemini-driven code reviews in GitHub
I recently installed the Gemini code review tool for GitHub. It’s free, and installation was easy. Today Gemini found its first real issue with my code. While the bug was very minor, it’s helpful to even have these minor bugs…
New Java client for rqlite
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. I have developed a new Java client for rqlite. It provides minimal abstraction and interacts directly with the rqlite HTTP API.…
New rqlite Go client
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine. I’ve decided to code a new, high-quality HTTP client library for rqlite. My hope is that this library will be useful…
Introducing flagforge: Simplifying Go Flag Code Generation
Developing Go applications often involves managing numerous command-line options, which can quickly become tedious to handle and document. Enter flagforge, a tool designed to automate the entire process.
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…
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…