[sqlite] WAL grows without bounds, short concurrent writes & reads

Hi, A very simple reproducer bash script using the sqlite3 CLI is appended at the end. I am using WAL mode in a setting with sequential writes and many concurrent reads. Due to WAL mode the readers don't get blocked, which is great and since writes are sequential, they never get blocked eith

Re: [sqlite] WAL grows without bounds, short concurrent writes & reads

There's code here, if you want to experiment with it:   https://sqlite.org/src/timeline?r=wal2 Docs:   https://sqlite.org/src/artifact/a807405a05e19a49 Dan. On 29/3/62 01:33, Florian Uekermann wrote: Hi, A very simple reproducer bash script using the sqlite3 CLI is appended at the end.

Re: [sqlite] WAL grows without bounds, short concurrent writes & reads

Dan, are there any plans to merge the wal2 branch into the trunk? > On Mar 29, 2019, at 7:10 AM, Dan Kennedy wrote: > > > There's code here, if you want to experiment with it: > > https://sqlite.org/src/timeline?r=wal2 > > Docs: > > https://sqlite.org/src/artifact/a807405a05e19a49 > >

Re: [sqlite] WAL grows without bounds, short concurrent writes & reads

On 3/29/19, Joshua Wise wrote: > Dan, are there any plans to merge the wal2 branch into the trunk? No, not at this time. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.

Re: [sqlite] WAL grows without bounds, short concurrent writes & reads

Awww sadness. Regardless, thanks for the update. > On Mar 29, 2019, at 11:07 AM, Richard Hipp wrote: > > On 3/29/19, Joshua Wise wrote: >> Dan, are there any plans to merge the wal2 branch into the trunk? > > No, not at this time. > > > -- > D. Richard Hipp > d...@sqlite.org >