[Phiresky] has a great answer to that: the sqlite-zstd extension offers transparent row-level compression for SQLite. There are other options, of course, but as the post mentions, each of these ...