On 06.04.2012 17:07, C. Michael Pilato wrote: > On 04/06/2012 11:02 AM, Branko Čibej wrote: >>> *sigh* I hadn't considered stale, compromised data not yet purged or >>> overwritten. Does SQLite's VACUUM statement help with this problem? >>> http://sqlite.org/lang_vacuum.html >> Vacuum will reorder the pages in the file to fill holes, but will then >> truncate the database file without first overwriting it with random >> crud. So, no, that's not good enough. > Hrm. Given the statements that the "VACUUM command rebuilds the entire > database" and that the "VACUUM command works by copying the contents of the > database into a temporary database file and then overwriting the original > with the contents of the temporary file", I would have expected better.
That's actually even worse, "overwriting the original" most likely means it does a FS-level rename, this leaving the /entire/ contents of the original file on disk. :) -- Brane
