Philip O'Toole

Philip O'Toole

Talking rqlite on the Contributor podcast

I recently had the opportunity to discuss rqlite, open-source, and distributed systems with Eric Anderson of Scale. It was great to be part of Eric’s series of podcasts on open-source software, modern software development, and where the industry is going.…

rqlite 8.10.0 – load large SQLite datasets fast

rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine. Release v8.10.0 introduces a new, high-performance, initialize-from-SQLite option. Known as Boot loading, it allows an rqlite node to be loaded with large (multi-GB)…

rqlite client libraries

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. I’ve added a listing of known client libraries to rqlite.io, hopefully developers will find them useful.

New Log Management features in GCP

I recently co-authored a blog post for the Google Cloud Platform Blog, along with my colleague Keith Chen. In the blog post we spoke about our latest features, which help organizations builds their own multi-tenant log management features on Cloud…

rqlite reaches 14,000 stars on GitHub

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. It passed another milestone this month in the open-source world, by passing 14,000 stars on GitHub — and just in time for…

Fix random(), stabilize tests

During the development of rqlite 8.0, a surprising behavior revealed itself through an unexpected venue: AppVeyor, the Continuous Integration (CI) system I employ for Windows testing. And even more unexpected was the resolution of previously unreliable unit tests.

On the way to rqlite 8.0

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Development for the 8.0 release has started, and should be an important release.

Speaking at GopherCon 2023

This September I’ll be speaking at GopherCon 2023. The conference takes place in San Diego, and I’ll be giving a talk on Building Distributed Systems in Go using the Raft consensus protocol. Much of my presentation will be based on…

rqlite upgraded to SQLite 3.42.0

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.20.0 upgrades SQLite from 3.39.0 to 3.42.0, bringing in a bunch of new SQLite features and bug fixes. You can download the…

Adding automatic S3 backups to rqlite

rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine. Version 7.15.0 has been released and now includes support for automated backups to Amazon Web Services (AWS) S3. This enhancement offers increased data…

rqlite 7.14.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.14.2 adds various bug fixes and improvements. Most of the rqlite source code was also run through GPT-4, and many of its…

9 years of open-source database development

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. I’ve been developing rqlite since 2014 and its design and implementation has evolved substantially during that time — and the design docs…

rqlite.io launched

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Today sees the launch of a dedicated website for rqlite. I built it using Hugo and Docsy, and deployed to Netlify, which…

rqlite 7.13.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.13.0 improves the rqlite command-line tool, storing and reloading command history across sessions. You can download the release from GitHub.

How I found a bug in SQLite

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I introduced a high-performance write-path into rqlite and, to my great surprise, it exposed a bug in SQLite.

rqlite 7.12.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.12.0 provides more convenient options for removing nodes from clusters, as well as more graceful shutdown options. You can download the release…

rqlite 7.11.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.11.0 adds support for automatically reaping nodes, and a new convenient query response format. You can download the release from GitHub.