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, 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 defaults work for the vast majority of use cases, occasionally rqlite requires some operational tweaks.
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 source of non-determinism from rqlite, allowing these functions to be used when working rqlite.
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 performance costs of the past.
Distributed systems present many challenges, but there is only one really hard problem: ensuring a consistent state across nodes, even in the face of network partitions, machine failures, or unexpected bugs. And a closely related requirement is ensuring up-to-date data reads — both requirements are the essential challenges that every distributed database must address.
Continue reading “Faster Reads, Same Guarantees: Linearizable Consistency in rqlite 8.32”
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 of synchronization primitives and race-free data structures I’ve developed for rqlite, and explain how I use them to program key aspects of the database. They might even be useful to others confronted with similar requirements.
Continue reading “Concurrency Control in Go: Inside rqlite’s Custom Synchronization Primitives”
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 easier to insert such data into rqlite, improving its usefulness as a data store.
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 Terms of Service prohibit you from deleting their nameservers!
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.
Continue reading “rqlite 8.30.0: Introducing Automatic Database Optimization”
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine.
Stephen Blum, CTO at PubNub has produced an informative video on rqlite. In it Stephen gives an overview of deploying rqlite, as well as showing basic interaction with the API.
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine.
Release v8.29.0 bakes more SQLite extensions into the Docker image, as well as improving extension management generally.
rqlite is a lightweight, open-source distributed relational database implemented in Go, and which uses SQLite as its storage engine.
With the release of rqlite 8.28.3, working with SQLite extensions in a Docker environment has become even more straightforward.
Continue reading “rqlite 8.28: Enhanced Docker Support for Seamless SQLite Extension Loading”