> On Oct 3, 2016, at 11:18 AM, Luca Ferrari <fluca1...@infinito.it> wrote: > > What is the right way to do it without having to stop the application > (and therefore without knowing when a new I/O operation will be > issued)?
You could use the attach/detach [1] functionality to transparently roll the logs over. Something like main -> attach current -> insert current.log Every now and then, change what ‘current’ points to. [1] https://www.sqlite.org/lang_attach.html _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users