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.

rqlite v3: Globally replicating SQLite

rqlite on GitHubrqlite is an open-source distributed relational database, which uses SQLite as its storage engine. rqlite is written in Go and uses Raft to achieve consensus across a set of SQLite databases. It gracefully handles leader election, and can tolerate machine failure.

With the v3 release series, rqlite can now replicate SQLite databases on a global scale, with very little effort. Let’s see it in action using the AWS EC2 cloud.

Continue reading

What I learned from programming databases

databaseProgramming a database is fascinating work. I’ve been deeply involved with developing open source databases for the past two years and programming a database is possibly the most instructive project one can ever complete as a software developer.

What’s really striking however, is how much my attitude towards databases has changed over the past 6 years. From a state of disinterest, I’ve come to think of these systems as a pinnacle of software engineering.

Continue reading

Philip O'Toole