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 13,000 stars on GitHub.
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
rqlite.io launched
rqlite 7.13.0 released
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 7.11.0 released
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 input substantially helped improve how rqlite runs on Kubernetes — and as a result rqlite 7.10.0 is out now. This latest release is also running an upgraded version of SQLite.
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 also been improved.
You can download the release from GitHub.
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 Johnson for the pure-Go SQLite parser.
You can download the release from GitHub.
The Engineering Management Myths Star Trek Teaches
Star Trek
has inspired huge numbers of people to become scientists, engineers, and programmers. I’m one of them. It often inspired me to work hard, build quality systems, and never give up when looking for the root cause of a tricky bug.
Continue reading “The Engineering Management Myths Star Trek Teaches”
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.
Continue reading “rqlite 7.6.0 released – now with ARM builds”
Building Secure and Reliable Systems at Google
I recently started reading Building Secure and Reliable Systems, which was authored by various folks at Google (some of whom I know). Since my work is at the intersection of so much of this — reliable logging systems which must also be secure, it’s an interesting read.
In my experience, the most challenging part about securing our systems are the constant trade-offs one needs to make. Since no system can be made 100% secure, knowing where the marginal risk is no longer worth addressing is quite difficult — I’m hoping this book improves my ability to make these trade-offs correctly.
rqlite 7.5.1 released
rqlite 7.5.0: Trading durability for write performance
rqlite is an open-source, lightweight, distributed relational database, which uses SQLite as its storage engine. Written in Go, It’s trivial to deploy, and easy to use.
Release 7.5.0 adds Queued Writes. This is the first time rqlite allows users to trade-off durability for much higher write performance.
Continue reading “rqlite 7.5.0: Trading durability for write performance”
rqlite reaches 10,000 stars on 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 of record insertion and modification, provided strong read consistency is enabled. Check out the full results on GitHub.
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 is a video recording of the talk.
rqlite 7.3.2 released
New Slack channel for rqlite
rqlite 7.0: Designing Node Discovery and Automatic Clustering
rqlite
is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine and Raft for distributed consensus. Release 7.0 is out now and introduces the first wave of new Node Discovery and Automatic Clustering features.
Continue reading “rqlite 7.0: Designing Node Discovery and Automatic Clustering”
Why are we still tailing log files?
Sit down with any developer today, even those at pretty new software companies, and you’ll see them doing something that programmers have been doing for years — you’ll see them tailing log files.
But why? Why are we still tailing logs?
rqlite 6.9.0 released
rqlite 6.8.2 released
Mentoring junior programmers: What I tell them is job number one
I’ve mentored, coached, managed, and reviewed many software developers throughout the years. There are many different areas one can discuss, but my most importance advice for engineers early in their career has never changed.
Continue reading “Mentoring junior programmers: What I tell them is job number one”