Re: [sqlite] How to do autosaving (commit data to disk) within an transaction?

2018-07-29 Thread Robert M. Münch
On 29 Jul 2018, at 14:07, Simon Slavin wrote: > On 29 Jul 2018, at 12:56pm, Robert M. Münch > wrote: > >> I want to add an autosave feature that stores some data at critical >> points/specific intervals. This data of course should be commited to disk, >> to survive any app crashes. > > Use a

Re: [sqlite] How to do autosaving (commit data to disk) within an transaction?

2018-07-29 Thread Simon Slavin
On 29 Jul 2018, at 12:56pm, Robert M. Münch wrote: > I want to add an autosave feature that stores some data at critical > points/specific intervals. This data of course should be commited to disk, to > survive any app crashes. Use a SAVEPOINT instead of COMMIT:

[sqlite] How to do autosaving (commit data to disk) within an transaction?

2018-07-29 Thread Robert M. Münch
When the user opens a file I start an outer-most transaction to be able to revert the file. So far so good. I want to add an autosave feature that stores some data at critical points/specific intervals. This data of course should be commited to disk, to survive any app crashes. But how can I