Here's what else is cool: You can change the default compression behavior of your entire server. On the Database Settings tab of the Server Properties dialog, you can select the option Compress Backup ...

[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 ...