[rabysh]

I think this could be a single pipeline?

ssh username@server "sqlite3 my_remote_database.db .dump | gzip -c" | gunzip -c | sqlite3 my_local_database.db

[rabysh]

gzip/gunzip might also be redundant if using ssh compression with -oCompression=on or -C on the ssh call

[sneak]

My first thought, too. It also seems somewhat glaringly obvious that it needs a `pv` in there, as well.