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 go
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.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…
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…
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…
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…
rqlite 8.37.0: Automatic reloading of X.509 Certificates
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…
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 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…
Concurrency Control in Go: Inside rqlite’s Custom Synchronization Primitives
rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Concurrency and synchronization are at the heart of any database — and distributed systems too. Today, I’d like to share the set…
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.
rqlite 8.27: loadable SQLite extensions support
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…
Building rqlite 9.0: Cutting Disk Usage by Half
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 reaches 15,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 very recently reached a new milestone in the open-source community by surpassing 15,000 stars on GitHub.
rqlite 8.24.9: now with multi-platform Docker images
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…
GopherCon 2023: Building Distributed Systems in Go
My GopherCon 2023 talk, Build Your Own Distributed System Using Go, has been published to YouTube. It was a great conference, and I appreciated the opportunity to share some lessons on designing, developing, and operating modern distributed systems in general,…