compress-json VS sqlite-zstd

May be try this https://github.com/beenotung/compress-json

Depending on how repeative the object keys are, you maybe able to save quite some spaces with compress-json [1].

Since the OP is using lz-string to do compression, I suppose the data should be repetitive.

[1] https://www.npmjs.com/package/compress-json

Have you compared LZ4 to other compression algorithms, zstd for example? ( https://github.com/phiresky/sqlite-zstd )

Given that LiteFS operates at the filesystem layer via FUSE, have you considered it against designs that use built-in features native to some filesystems? For example, I've considered a similar system design based on a single ZFS primary node that streams ZFS snapshots to reader nodes. With some coordination service (e.g. consul) it could still allow for the whole node promotion process.

There's library to compress sqlite databases with extensions like sqlite-zstd.

You can also try sqlite-zstd [1], which is an sqlite extension allows transparent compression of individual rows by automatically training dictionaries based on groups of data rows.

Disclaimer: I made it and it's not production ready

[1] https://github.com/phiresky/sqlite-zstd