posts/2021/1001/distributed-fault-tolerant-sqlite-databases/

[utterances-bot]

Distributed, Fault-Tolerant SQLite Databases

Globally distributed database for reliability with SQLite as a storage engine, allowing for ease of implementation, setup and maintenance.

https://nox.im/posts/2021/1001/distributed-fault-tolerant-sqlite-databases/

[freeekanayaka]

Thanks for the detailed review!

A couple of notes about dqlite:

• It now uses vanilla SQLite.

• Even if it replicates WAL pages instead of SQL text, it's still faster than rqlite, mainly because of its optimized C implementation, wire protocol and the lack of context switch caused by calling SQLite C functions from Go via CGO. See https://gcore.com/learning/comparing-litestream-rqlite-dqlite/ for some benchmarks.