4 ms·

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 1y ago
  gzip/gunzip might also be redundant if using ssh compression with -oCompression=on or -C on the ssh call
• sneak 1y ago
  My first thought, too. It also seems somewhat glaringly obvious that it needs a `pv` in there, as well.