Tag database

rqlite 7.16.0 – restore your system from S3

rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine. Version 7.16.0 has been released and now includes support for restoring your rqlite system automatically from AWS S3. With this in place you…

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…

Creating rqlite 7.14.0 with GitHub Copilot

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.14.0 has been released and adds comprehensive support for Mutual TLS. What makes this release of rqlite different is that much of…

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…

rqlite 7.6.0 released – now with ARM builds

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.6.0 improves access-control options, and also has official ARM and ARM64 builds for the first time.

rqlite 7.5.1 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.5.1 supports more network-related configuration options. You can download the release from GitHub.

Testing rqlite read consistency

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Nienke Eijsvogel, Ruben van Baarle and Daan de Graaf recently ran Jepsen-style testing of rqlite. Their tests showed that rqlite maintains linearizability…

Talking Distributed Systems at Hacker Nights

I recently had the opportunity to talk distributed systems and rqlite at the Hacker Nights NYC Meetup. It was great chance to speak with some  folks, and discuss rqlite, its design, and how it operates. The presentation is available, as…

rqlite 7.3.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.3.2 upgrades rqlite to use SQLite 3.38.0. You can download the release from GitHub.

rqlite 6.9.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.9.0 adds support for SQLite Named Parameters. You can download the release from GitHub.

rqlite 6.8.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.8.2 adds control over startup initialization. You can download the release from GitHub.

rqlite: static linking and smaller Docker images

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. There have been a series of releases recently, which make deployment on Linux even easier, and significantly decrease the Docker footprint.

rqlite 6.6.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.6.2 increases maximum intra-cluster communication message size. You can download the release from GitHub.

rqlite 6.6.1 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.6.1 improves handing of some error cases. You can download the release from GitHub.