Re: [sqlite] Fill empty space with random

2018-10-15 Thread thilo jeremias
> > In the simple case, the VFS that the sqlite Db is mounted in is encrypted > with a long key. The key has cycles at 4096(A) and 16(B1-Bn) bytes > (4096/16 = 256 cycles of Bn); such that each sector is masked with > A^B1(256x), A^B2(256x), ... all together there is no repetition because the >

Re: [sqlite] Fill empty space with random

2018-10-14 Thread Luuk
On 14-10-2018 17:07, J Decker wrote: > (sorry for the math err s/16/32/g and s/512/256/ - I double and halfed > the wrong directions.) > > On Sun, Oct 14, 2018 at 7:57 AM J Decker wrote: > >> >> On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote: >> >>> On 14-10-2018 16:17, Simon Slavin wrote: On

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
(sorry for the math err s/16/32/g and s/512/256/ - I double and halfed the wrong directions.) On Sun, Oct 14, 2018 at 7:57 AM J Decker wrote: > > > On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote: > >> On 14-10-2018 16:17, Simon Slavin wrote: >> > On 14 Oct 2018, at 12:56pm, J Decker wrote: >> >

Re: [sqlite] Fill empty space with random

2018-10-14 Thread Simon Slavin
On 14 Oct 2018, at 3:24pm, J Decker 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...

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote: > On 14-10-2018 16:17, Simon Slavin wrote: > > On 14 Oct 2018, at 12:56pm, J Decker 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

Re: [sqlite] Fill empty space with random

2018-10-14 Thread Luuk
On 14-10-2018 16:17, Simon Slavin wrote: > On 14 Oct 2018, at 12:56pm, J Decker 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 > (B) Your operating

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
On Sun, Oct 14, 2018 at 7:17 AM Simon Slavin wrote: > On 14 Oct 2018, at 12:56pm, J Decker 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;

Re: [sqlite] Fill empty space with random

2018-10-14 Thread Simon Slavin
On 14 Oct 2018, at 12:56pm, J Decker 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 (B) Your operating system may have a setting to do this automatically to

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
On Sun, Oct 14, 2018 at 5:48 AM Bob Gailer wrote: > On Oct 14, 2018 7:57 AM, "J Decker" 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

Re: [sqlite] Fill empty space with random

2018-10-14 Thread Bob Gailer
On Oct 14, 2018 7:57 AM, "J Decker" 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

[sqlite] Fill empty space with random

2018-10-14 Thread J Decker
Is there maybe a compile option for sqlite to fill empty space in a db with random data rather than 0 ? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users