alt Hacker NewsI love litestream. I've used it with pocketbase and it works. sqlite is a great building block for almost everything.
Does anyone know whether you could use this to stitch together a bunch of .db files (that share the same schema) in an ad-hoc way?
For example, if I decided I wanted to synchronize my friend's .db file, could I enable this using litestream? And, what if my friend wanted to sync two of his friends' .db files, but I'm only interested in his changes, not theirs? I assume this kind of fan out is not possible, but it would be fun if so.
If you can have multiple writers to a single database then you'd need to look at something like cr-sqlite[1] that uses CRDT to figure out conflicts. If you're just replicating separate databases then you might be able to replicate each one using Litestream and then use SQLite's ATTACH[2] to connect them together. There is a limit on how many databases you can attach together in a session though.
[1]: https://github.com/vlcn-io/cr-sqlite
[2]: https://sqlite.org/lang_attach.html