Re: [sqlite] [WAL] Querying/Finding out the WAL size (in pages) without trying to checkpoint

2016-09-20 Thread Jose Arroyo
On 20 September 2016 at 14:29, Simon Slavin <slav...@bigfraud.org> wrote: > > On 20 Sep 2016, at 8:59am, Jose Arroyo <jose.m.arroyo...@gmail.com> wrote: > > > My current issue is that I'm encountering WAL checkpoint starvation and > I'm > > trying to figure

Re: [sqlite] [WAL] Querying/Finding out the WAL size (in pages) without trying to checkpoint

2016-09-20 Thread Jose Arroyo
dersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite- > Forensic-Toolkit > -Forensic Toolkit for SQLite > email from a work address for a fully functional demo licence > > > On 20 September 2016 at 08:59, Jose Arroyo <jose.m.arroyo..

[sqlite] [WAL] Querying/Finding out the WAL size (in pages) without trying to checkpoint

2016-09-20 Thread Jose Arroyo
From looking at the source code, it seems to me that the values returned on wal_hooks come from some sqlite's internal variables so it doesn't seem to be possible to query the DB for it. I suspect that the WAL size can be calculated from the WAL index file somehow, but I don't really grok how it

[sqlite] Fwd: SQLite 3.14.2 autoconf (shell) doesn't build with SQLITE_OMIT_AUTHORIZATION, undefined reference

2016-09-19 Thread Jose Arroyo
Hello everyone, I couldn't find this in the existing bug list so I decided to send this email. I downloaded the latest SQLite autoconf version from https://www.sqlite.org/2016/sqlite-autoconf-3140200.tar.gz and tried building it using this compile option, doing

[sqlite] SQLite 3.14.2 autoconf (shell) doesn't build with SQLITE_OMIT_AUTHORIZATION, undefined reference

2016-09-16 Thread Jose Arroyo
Hello everyone, I couldn't find this in the existing bug list so I decided to send this email. I downloaded the latest SQLite autoconf version from https://www.sqlite.org/2016/sqlite-autoconf-3140200.tar.gz and tried building it using this compile option, doing