rqlite 4.1.0 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v4.1.0 is now out. This release includes some minor enhancements and bug fixes. You can download the release from 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
Tag programming
Java client for rqlite
I’ve started a new Java client for rqlite, the lightweight distributed relational database, build on SQLite. I’m using Eclipse as my IDE and it’s working well so far. You can check out the source on Github here.
rqlite v4.0.1 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v4.0.1 is now out. This release includes some minor bug fixes. You can download the release from GitHub.
Go, gRPC, and PostgreSQL
I’ve started experimenting with Go and gRPC. To that end I’ve written a simple service that accepts connections from gRPC clients, allowing those clients to send queries to PostgreSQL. So far it’s been pretty straightforward. You can check out the…
rqlite now available with node-to-node encryption
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. It’s been over a year since the last major release and v4.0.0 is now available.
rqlite v3.14.0 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.14.0 is now out. This release is the first built with Go 1.8. You can download the release from GitHub.
Percolate at the San Francisco Python Meetup
The new Analytics system, built by my team at Percolate, allows our end-users to program their own custom calculations, offering them the ability to precisely customize the product for their needs. At the center of that feature is a Pratt…
rqlite v3.13.0 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.13.0 is now out. This release includes minor enhancements and a couple of bug fixes. You can download the release from GitHub.
rqlite v3.12.1 now with Discovery Service for easier clustering
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.12.1 has been released. This release includes integration with a new Discovery Service, allowing nodes to automatically connect and form a cluster. This can be very…
Building a cluster discovery service with AWS Lambda and DynamoDB
In this post I describe how I built a serverless cluster discovery service for rqlite, the distributed relational database built on SQLite. Built using the AWS API Gateway service, AWS Lambda, and DynamoDB, it means rqlite nodes no longer need…
rqlite v3.10.0 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.10.0 has been released. This release includes some minor configuration control and logging enhancements. You can download the release from GitHub.
rqlite v3.9.2 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.9.2 is now out. This release includes a couple of significant bug fixes. You can download the release from GitHub.
Building a snap for rqlite
I’ve started experimenting with one of the newest packaging systems — Canonical’s Snap format. I learned about Snap from Mark Shuttleworth when he let me know that he had created a rqlite Snap. It seems pretty clean and straightforward so far — I’ve…
rqlite v3.8.0 released
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.8.0 is now out. This release includes some minor enhancements and bug fixes. You can download the release from GitHub.
Stop asking "how much data do you have?"
In every field there is a question that, while it sounds interesting, betrays a naiveté and lack of sophistication. In my field — SaaS and data platforms — it’s how much data do you have?
Some of my favourite programming books
I was recently asked by some colleagues about my favourite books on programming. And not just books on coding, but on improving their understanding of successful teams.
Load SQLite dump files into rqlite v3.7.0
rqlite is a lightweight distributed relational database, with SQLite as its storage engine. With release v3.7.0 you can load SQLite dump files directly into rqlite. This makes restoring from a backup, or migrating an existing SQLite database to rqlite much…
Ekanite at the San Francisco Go Meetup
I gave a presentation on Ekanite — the syslog server with built-in search — tonight at the San Francisco Go Meetup. It was an enjoyable evening, and I had a chance to discuss why I built Ekanite, how it works, and…
rqlite v3.6.0 released
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.6.0 is out. With this release a new node can now join an existing cluster though any node of that cluster, not just through the leader node.…
rqlite v3.5.0 released
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.5.0 is out. This release supports important control of foreign key constraints, in the underlying SQLite database. You can download the release from GitHub.
rqlite v3.4.1released
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.4.1 is out. This release includes some minor fixes as well as source code improvements (linting). You can download the release from GitHub.
The evolution of the rqlite source code
rqlite is an open-source distributed relational database, with SQLite as its storage engine. Check out this cool video, showing the evolution of the source code.
rqlite v3.4.0 released
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.4.0 is out, which includes a minor change to the HTTP responses. You can download the release from GitHub.
Be a Conviction Engineer
I’m a conviction engineer. To me it’s the only way to be an effective engineer, software developer, and technical leader. You’ve simply got to truly believe in the value of what you do, and you’ve got to believe in doing…
rqlite v3.3.0 released
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.3.0 has been released and includes new functionality to control the Raft consensus subsystem, along with improvements to the CLI. You can download the release from GitHub.