On 11/7/13, L. Wood <lwoo...@live.com> wrote: > What directories can SQLite possibly write files to? > > * I'm aware of the files that SQLite can write to the *same* directory as > that of the actual database file,
Take particular attention to master journal files. As http://sqlite.org/tempfiles.html describes, these can be created if you modify multiple attached databases in the same transaction, then if the application crashes during the transaction, opening any of those databases later will open the master journal and all the other database files affected. > "The manner in which SQLite uses temporary files is not considered part of > the contract that SQLite makes with applications. Note that http://sqlite.org/c3ref/vfs.html tries to give some more concrete guarantees about what files can be opened. Ambrus _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users