nostr:npub1y4s7hjcxn9e2dxakrl98taqevp8vk9fn4axpkejqcuvackcg7f6sgnvgt8 nostr:npub18qdpy73ygsxgeg0p7qg6kxzry5hpn3cp4fsfhdw9a89arv5vx0psyg9564 datasette-litestream doesn't give you multi-leader writes, or even read-replicas - it's purely a disaster recovery mechanism, which gives you a recoverable S3 backup from a few seconds ago if something goes wrong

LiteFS will provide read-replicas, but still only a single writer

If you want multi-writers I suggest looking into things like cr-sqlite: https://til.simonwillison.net/sqlite/cr-sqlite-macos