Dqlite – High-Availability SQLite (dqlite.io)

Article summary

Dqlite is a high-availability version of SQLite, developed by Canonical. It is a library that can be embedded in any language that can interoperate with C, and it supports full transactions and frame-based replication. Dqlite is designed to be used in distributed systems, such as IoT devices or cloud platforms. It has been around for 2.5 years and has just released version 1.0.0.

Main themes

• Dqlite
• SQLite
• High-Availability
• Distributed Systems
• IoT
• Cloud Platforms

What commenters say

• Dqlite is a library, whereas rqlite is a full RDBMS application, making them suitable for different use cases.
• The difference in replication methods between Dqlite and rqlite can lead to differing values in a cluster due to non-deterministic commands.
• Dqlite's frame-based replication allows for non-deterministic commands, such as those using RANDOM(), to be handled differently than in command-based replication.
• Some commenters are unsure about the use cases for Dqlite, while others see potential applications in distributed IoT devices or cloud platforms.
• The ability to query the DB on disk using the regular sqlite3 cli tool is seen as an advantage by some users.
• Dqlite's support for multiple architectures, including ARM, X86, POWER, and IBM Z, makes it a versatile solution for various platforms.
• The release of version 1.0.0 marks a significant milestone for Dqlite, with a commitment to stable public APIs and long-term support.