Oddbean new post about | logout
 @2561ebcb @381a127a 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