On Sun, Oct 14, 2018 at 5:48 AM Bob Gailer <bgai...@gmail.com> wrote:
> On Oct 14, 2018 7:57 AM, "J Decker" <d3c...@gmail.com> wrote: > > > > Is there maybe a compile option for sqlite to fill empty space in a db > with > > random data rather than 0 ? > > I don't know about compile options. > > You could do a 1 time update to set all 0 columns to random(1,99), and > create a trigger to do the same on insert. > > This, of course is on a table-by-table basis. > Doesn't work for all the empty space outside of the table; between tables; not unused pages from deleted records, .... > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
