sqlite icon indicating copy to clipboard operation
sqlite copied to clipboard

Bump SQLite Version for `VACUUM INTO` improvements

Open upsampled opened this issue 5 months ago • 0 comments

VACUUM INTO fits really well into the general use case of "I need a persistent, read-only backup that is as small as possible". Only issue was that it used to not call fsync, so you could think you have a backup safely secured on disk and then find out after a hard power cycle that it was not actually there (great times!).

Anyhow this was fixed 3.45.1 SQLite and as of writing we are at 3.38.5 SQLite https://github.com/sqlite/sqlite/commit/80b30f995eacfafaba95f76d25b5ae2c37f478e9

The SQLite Forum post about this is here (with recent entries explaining how the documentation could use some work) https://sqlite.org/forum/info/8c83764a7355f6cc8208cdf96e533dd2f91f939770c193d20980fa45140e8908

Closing note, looks like @crawshaw is a fan of VACUUM INTO as well: https://github.com/crawshaw/sqlite/issues/36#issuecomment-465752896

upsampled avatar Sep 12 '25 13:09 upsampled