Re: [sqlite] Use journal after program crashed

2016-05-25 Thread Paul Sanderson
Cecil, Richard If the WAL file contains multiple commits then it is possible (with appropriate tools) to use any of commits and effectively roll back to a chosen previous version. How much of this data you can get at depends upon the size that the WAL file will auto checkpoint and also the size

Re: [sqlite] Use journal after program crashed

2016-05-24 Thread Richard Hipp
On 5/24/16, Cecil Westerhof wrote: > 2016-05-25 3:49 GMT+02:00 Richard Hipp : > >> On 5/24/16, Cecil Westerhof wrote: >> > Until now I did not need it, but better inform before I do. ;-) >> > >> > When a program crashes it is

Re: [sqlite] Use journal after program crashed

2016-05-24 Thread Cecil Westerhof
2016-05-25 3:49 GMT+02:00 Richard Hipp : > On 5/24/16, Cecil Westerhof wrote: > > Until now I did not need it, but better inform before I do. ;-) > > > > When a program crashes it is possible that you have a journal file with > > things that are not

Re: [sqlite] Use journal after program crashed

2016-05-24 Thread Richard Hipp
On 5/24/16, Cecil Westerhof wrote: > Until now I did not need it, but better inform before I do. ;-) > > When a program crashes it is possible that you have a journal file with > things that are not committed. Is there a way to find out what those are? > (And selectively

[sqlite] Use journal after program crashed

2016-05-24 Thread Cecil Westerhof
Until now I did not need it, but better inform before I do. ;-) When a program crashes it is possible that you have a journal file with things that are not committed. Is there a way to find out what those are? (And selectively commit?) -- Cecil Westerhof