On Sun, Oct 14, 2018 at 7:17 AM Simon Slavin <[email protected]> wrote:
> On 14 Oct 2018, at 12:56pm, J Decker <[email protected]> wrote: > > > Is there maybe a compile option for sqlite to fill empty space in a db > with random data rather than 0 ? > > There is not. But > > (A) It may be an easy change to the source code > Sure; figured I'd toss out the question to see if there was at least a springboard > (B) Your operating system may have a setting to do this automatically to > freed blocks on a storage device. > (C) Your device driver may have a setting to do this automatically to > freed blocks on the device. > > B and C would apply if there was a vacuum also; adding data, and deleteting data, the db ends up with lots of zeros.... Also between non-integral pages; messages that are say 700 bytes; so 4096% 700 is 596; which is all filled with zeros... if I end up with messages that are say 2200 bytes; nearly half the page is blank for a while. > That type of security is normally done at OS or device level, not by each > individual app. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
