On 7 Nov 2013, at 5:38pm, Richard Hipp <d...@sqlite.org> wrote:

> Rollback journal files might be closed and reopened.

Okay.  That gives us more of the answer to the original question.

Wood, this is the only file that SQLite would care about if moved.  And 
technically you could use NSNotification to tell you if someone moved a journal 
file while SQLite was using it.  But in practise, under both OS X and iOS, it 
doesn't matter.  Losing that file between transactions isn't going to corrupt 
your database and if someone does move or delete it at that point the best 
thing your app could do is crash, so the user knows not to do that.

So yes, OS X does give you a mechanism for keeping track of files being moved.  
But there's not much point in using it with a SQLite database.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to