Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On Tue, Aug 16, 2016 at 2:29 PM, Simon Slavin wrote: > VACUUM destroys tables (and indexes) and makes new ones, so it frees pages > and allocates new ones. The content of the 'unused' bytes in the > newly-allocated pages would not have anything to do with the content of the > pages which used to

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On 16 Aug 2016, at 1:46pm, Dominique Devienne wrote: > On Tue, Aug 16, 2016 at 2:29 PM, Simon Slavin wrote: > >> VACUUM destroys tables (and indexes) and makes new ones, so it frees pages >> and allocates new ones. The content of the 'unused' bytes in the >> newly-allocated pages would not ha

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On Tue, Aug 16, 2016 at 2:29 PM, Simon Slavin wrote: > > If you're to use some of these bytes for your own values you will > presumably be modifying the pager module of SQLite, as mentioned in the > "Page Cache" section of > The pager is not an extension point o

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On 16 Aug 2016, at 12:21pm, Dominique Devienne wrote: > What are the guarantees, if any, SQLite makes about preserving what's in > these reserved bytes, > for example during vacuuming, or any operation that moves pages around? > > And if these reserved bytes are not preserved (logical in a way)

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On Tue, Aug 16, 2016 at 12:09 PM, Clemens Ladisch wrote: > sanhua.zh wrote: > > It describles the"Bytes of unused‘reserved' space at the end of each > page”. I think it’s the exact thing what I need. > > But I have no idea how to use it. It seems that there is no interface to > do this. > > sqlit

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

sanhua.zh wrote: > It describles the"Bytes of unused‘reserved' space at the end of each page”. I > think it’s the exact thing what I need. > But I have no idea how to use it. It seems that there is no interface to do > this. sqlite3_test_control(), or a hex editor: http://stackoverflow.com/quest

[sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

Now I want to add my customize data for each page. And I find thatIt describles the"Bytes of unused‘reserved' space at the end of each page”. I think it’s the exact thing what I need. But I have no idea how to use it. It seems that there is no interface to do this. Can any one tell me about the d