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 convenient, allowing clusters to be dynamically created.

You can download the release from GitHub.

Building a cluster discovery service with AWS Lambda and DynamoDB

AWS LambdaIn 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 to be passed the network address of an existing node in a cluster, and can instead connect automatically.

Continue reading Building a cluster discovery service with AWS Lambda and DynamoDB

Analytics 2.0 goes live at Percolate

Today sees the launch of Analytics 2.0 on the Percolate platform. After 12 months of hard work by my team, I am very proud of the new platform.

1 year ago the San Francisco team was tasked with rebuilding the Analytics system at Percolate. In place of our legacy MySQL-based system, we now have a brand new architecture, based on Apache Kafka and Elasticsearch. It’s more responsive, more flexible, and offers much richer functionality.

You can learn all about the new system on the Percolate blog.

rqlite now supported on Microsoft Windows

Microsoft Windowsrqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. Thanks to the power of the Go tool chain, it is compatible with Microsoft Windows without any extra effort.

To ensure that it remains compatible with Windows, I have enabled CI for Windows using AppVeyor. After some help from the open-source community, it’s up and running now.

Philip O'Toole