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.
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
Philip O'Toole
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…
Adding automatic Google Cloud Storage Backup and Restore to rqlite
rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine. Version 8.39 has been released and now includes support for automated backup and restore to and from Google Cloud Storage. This enhancement offers…
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…
GPT is writing the GitHub issues, Copilot is fixing them
rqlite is a lightweight, open-source, distributed relational database written in Go. It uses SQLite as its storage engine and Raft for consensus. Last week, I wrote about my experience with language models, how they evolved from simple Python helpers to full-blown design partners and even…
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…
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 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.
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.
rqlite reaches 16,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 16,000 stars on GitHub.
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…
rqlite 8.33.0: Date and Time function support
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.33.0 is out now and adds support for automatic rewriting of SQLite Date and Time functions. This removes another…
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…
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…
From Google Cloud to WordPress.com
After four years of running this blog on Google Cloud, I’ve migrated it to WordPress.com. The migration process was hassle-free and worked quite well. The only unexpected change I had to make was to transfer philipotoole.com to WordPress, as Cloudflare‘s…
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.