On 14 Oct 2018, at 3:24pm, J Decker <d3c...@gmail.com> wrote: > 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...
True. And note the non-intuitive usage patterns of solid-state storage devices, where changing one byte of a 'sector' can result in the old 'sector' being freed and a new one used. Changes to SQLite (or anything else at app level) cannot help with this sort of thing. It comes down to why you're concerned about security, and whether you're concerned that someone may physically steal your hardware, or whether you're just sharing a virtual machine host with a possibly-hostile organisation. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
