[d34th0rl1f3]

You can save time by using `zcat` instead of `cat` and skip the `gunzip my_local_database.db.txt.gz` step.

[Slasher1337]

Why would anyone use gzip instead of zstd in 2025? zstd is superior in every dimension.

gzip is a legacy algorithm that imo only gets used for compatibility with legacy software that understands nothing but gzip.

[nodesocket]

You don’t need cat at all for the restore. Can simply do:

sqlite3 data/database.db < “{backup_file}"

[_joel]

You could speed up by using pigz (parallel gzip) too.

[masklinn]

If you're going to use a less universal tool for compression you might as well go with zstd.