d34th0rl1f3's comments

On: I'd tell you a UDP joke…

[d34th0rl1f3]

those who get it, and ...

[lucb1e → d34th0rl1f3]

Ah, right! :D

On: A faster way to copy SQLite databases between computers

[d34th0rl1f3]

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

[Slasher1337 → d34th0rl1f3]

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 → d34th0rl1f3]

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

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

[_joel → d34th0rl1f3]

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

[masklinn → _joel]

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