Comment by simonw
13 days ago
That's fine if SQLite isn't running, but you risk corruption if you copy a file while it is being actively written to.
VACUUM INTO eliminates that risk.
13 days ago
That's fine if SQLite isn't running, but you risk corruption if you copy a file while it is being actively written to.
VACUUM INTO eliminates that risk.
Thank you for mentioning this. I was planning to do exactly this soon and had no idea.