Philip O'Toole

Philip O'Toole

  • Joined: July 9, 2020
  • Articles: 317
  • Comments: 58

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.

Replacing Postgres with rqlite

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I helped Replicated replace their use of PostgreSQL with rqlite. This brought much easier operation and high-availability to their Application Manager.

rqlite 7.10.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Replicated, a company which helps software vendors ship software to end users, recently migrated from PostgreSQL to rqlite. Along the way their…

rqlite 7.8.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.8.0 provides more convenient options for retrieving a backup of the underlying SQLite database. The guide for running rqlite on Kubernetes has…

rqlite 7.7.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.7.0 is the first release to add support for non-deterministic functions, specifically RANDOM. It accomplishes this via statement-rewriting. Many thanks to Ben…