3 ms·
You can save time by using `zcat` instead of `cat` and skip the `gunzip my_local_database.db.txt.gz` step.
by d34th0rl1f3 1y ago
You can save time by using `zcat` instead of `cat` and skip the `gunzip my_local_database.db.txt.gz` step.
- _joel 1y agoYou could speed up by using pigz (parallel gzip) too.
- masklinn 1y agoIf you're going to use a less universal tool for compression you might as well go with zstd.
- Slasher1337 1y agoWhy 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 1y agoYou don’t need cat at all for the restore. Can simply do: sqlite3 data/database.db < “{backup_file}"