All posts by Philip O'Toole

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.