Re: [sqlite] Persistence of -wal and -shm

On 29 Nov 2012, at 5:18pm, Richard Hipp wrote: > On Thu, Nov 29, 2012 at 12:04 PM, Simon Slavin wrote: > >> Should these journal files exist even when nothing is open or has crashed >> ? I thought that properly-closed connections deleted journal files

Re: [sqlite] Persistence of -wal and -shm

On 11/30/2012 12:04 AM, Simon Slavin wrote: I have a folder with 17 independent databases in, each of them opened for reading an writing occasionally. Two of them have both -wal and -shm files, even though they shouldn't have been opened for read or write for days, and the last opening of each

Re: [sqlite] Persistence of -wal and -shm

On Thu, Nov 29, 2012 at 12:04 PM, Simon Slavin wrote: > I have a folder with 17 independent databases in, each of them opened for > reading an writing occasionally. Two of them have both -wal and -shm > files, even though they shouldn't have been opened for read or write

[sqlite] Persistence of -wal and -shm

I have a folder with 17 independent databases in, each of them opened for reading an writing occasionally. Two of them have both -wal and -shm files, even though they shouldn't have been opened for read or write for days, and the last opening of each one closed connections properly without