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