News for hackers. Stuff that matters.
Re:A faster way to copy SQLite databases between computers by rabysh on Thursday May 01, 2025 @07:59AM (#43856527)
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

Re:A faster way to copy SQLite databases between computers by rabysh on Thursday May 01, 2025 @08:01AM (#43856540)
gzip/gunzip might also be redundant if using ssh compression with -oCompression=on or -C on the ssh call
Re:A faster way to copy SQLite databases between computers by sneak on Thursday May 01, 2025 @01:44PM (#43860960)
My first thought, too. It also seems somewhat glaringly obvious that it needs a `pv` in there, as well.