On Mon, Feb 10, 2014 at 4:40 PM, Stephen Chrzanowski <pontia...@gmail.com>wrote:
> Personally, I don't buy that DropBox is the culprit as I've done this kind > of thing a few times in a few applications of my own, however, I'm the > single user that works on that single account, and any app that uses DB is > usually under development and "closed" on any other geographical site. > That is the same situation with me; I only develop and use this application, and thus this database, on one computer only. I haven't tried the Dropbox syncing in at least two years, though it used to work. But I'm getting the sense from others here responding to this post that Dropbox does put a lock on the database file in order to back it up, and it has to do that whenever the data is changed, and so one might wind up having Dropbox lock the file when you need to write to it. Oddly, I make changes to the database hundreds of times a day and only get this lock conflict--if that is indeed what is happening--every now and then, like every few weeks or months, particularly when the RAM is filled up with a memory leaky Firefox and other open applications...possibly because the lock is held longer during those times? > I'd suggest looking into opening the database with an exclusive lock, Can you say more about that? I'm not familiar with that option. > or look into using the Backup API that SQLite uses. > Using the SQLite Backup API, when your program starts, do a flat-file > standard file copy from DropBox to a different location (%USERPATH% or > something similar) and wait for the file to finish to copy. Then open that > backed up file and work on it. When your user saves, or closes your > application, use the backup API to put the file back to DropBox directory. > This isolates WAL file writes to the local system and not to DB. > That sounds similar to what James Lowden is suggesting in this thread. I'll look into that, and will probably have questions for the list later. Thanks, Che _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
