Be interested to hear a comparison between this lib and litestream/litefs, which seem to be actively developed by fly.io for a similar use case
cr-sqlite [0] is another option. It has the added benefit of being able to run in the browser (persisting to IndexedDB a la absurd-sql, though it uses a fork of wa-sqlite [1]). In theory it could also persist to the Origin Private Filesystem via SQLite's official impl, though switching doesn't seem to be strictly better [2]. A con is that it doesn't enforce foreign key constraints (though of course you can still do joins). Cr-sqlite also has better documentation about what CRDTs it supports than Mycelite [3], which is something I brought up in a recent thread [4](which might have triggered this post). I'm personally using cr-sqlite in an Anki clone I'm building [5] and have only positive things to say about cr-sqlite and its maintainer.
[0] https://github.com/vlcn-io/cr-sqlite/
[1] https://github.com/rhashimoto/wa-sqlite/
[2] https://github.com/rhashimoto/wa-sqlite/discussions/63
[3] https://github.com/vlcn-io/cr-sqlite/#how-does-it-work