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.
[ Parent
| on HN ]
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/?
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.