News for hackers. Stuff that matters.
Re:A faster way to copy SQLite databases between computers by mixmastamyk on Thursday May 01, 2025 @07:02PM (#43864320)
Believe there are command-line flags necessary to make it do that though: --inplace --no-whole-file
Re:A faster way to copy SQLite databases between computers by exsysadmin on Saturday May 03, 2025 @07:22AM (#43878327)
--no-whole-file is the standard, except for local paths (on the same system, the delta-transfer algorithm would be a waste of work, as it reads src and dst to find the delta with rolling checksums -- over the network it can save lots of time and bandwidth)

--inplace is independent of that: it specifies writing directly to target files (instead of write to temp file and rename to target after completion)