News for hackers. Stuff that matters.
Re:Around the World with SQLite3 and Rsync by samruby on Friday June 23, 2023 @06:40AM (#36445068)
Author here, and fly.io employee. I have an app that allows dance studios to schedule "heats" for competitions. Multiple dance studios, in separate locations, use this app with separate databases. I merely blogged some techniques that I found useful for my app. Most apps won't need any of this, but in the future when somebody has a related problem, I wanted something I could point to to show some techniques that might be helpful.
Re:Around the World with SQLite3 and Rsync by barnabask on Friday June 23, 2023 @08:34AM (#36445989)
Why rsync and not Fly.io's own https://fly.io/docs/litefs/?
Re:Around the World with SQLite3 and Rsync by samruby on Friday June 23, 2023 @09:19AM (#36446448)
The short answer is that litefs uses a single primary node (see: https://fly.io/docs/litefs/proxy/). I work with Ben so I imagine that over time we'll find a configuration that works with multiple databases each with their own primary node, but until then, this works for now.