Software engineering, distributed systems, databases, and the teams that build them
Software engineering, distributed systems, databases, and the teams that build them
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…
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 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 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 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…
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 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 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…
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 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 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…
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…
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.…
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…
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.
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 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.
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 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…
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 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…
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…
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 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…
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…