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

Reply via email to