On Wed, 22 Apr 2015 13:50:43 +0100 Simon Slavin <slavins at bigfraud.org> wrote:
> Dear folks, <snip> > > Assuming no hardware/OS faults is it possible for any other > SQLite-created files to still exist ? Journal ? Temp index ? > Shared memory ? Anything ? a) If the app crash, it may create a dump file with sqlite cache information. b) If memory is low and depending of the OS, perhaps part of app code/data may reside on swap for a time after quit the app. c) In Windows, antivirus software may lock a temp file and don't allow delete it d) If use ZFS or similar filesystem, a snapshot of file system is taken each 10-30 secs., you can go back in time and recover filesystem state from 2 days ago (up to 6 months IIRC) > I have read <https://www.sqlite.org/tempfiles.html>. > > Simon. --- --- Eduardo Morras <emorrasg at yahoo.es>
