3 ms·
Ever since I saw Cloudflare D1, I have been obsessed by distributed SQLite. Primary reason is the cost of managing and owning it is relatively low, but then it
by srameshc 2y ago
Ever since I saw Cloudflare D1, I have been obsessed by distributed SQLite. Primary reason is the cost of managing and owning it is relatively low, but then it was still not easy managing Rqlite. I wanted managed and I recently found Turso and it is amazing, but it's hard to understand the reads and writes with such databases. I knew about Fly.io investment in this area but I did not know about the offering Litefs. The author made some good arguments and probably it is wise to listen about the challenges and think twice before making it a default database out of sheer excitement and cost.
- summarity 2y agohttps://litesync.io/en/ https://litesync.io/en/ is a mature way of distributing SQLite with arbitrary topologies and no modifications to client code. Supports multi primary write and DDL replication. It’s a paid solution, but that follows the model of all commercial SQLite mods (one time license fee). I use it, though just for a simple case of having a live replica of a production server running SQLite so I can try out migrations and generally work in an isolated copy.