hmm, I am using sqlite as a project file that keeps track of a variety of information (usually a couple dozen megabytes in size per project). My initial post assumed a single user with a couple windows open. The file might be accessed by another user on a local area network. Usually no more than a few people at the same time for a specific project file. My program runs on windows and mac with a local area network connecting the computers. Each computer has its own copy of the program, but may share the database file which may be located on any of the computers. So I am wondering whether I should implement my own locking logic in my program.
--------------------- Scott Doctor scott at scottdoctor.com --------------------- On 5/2/2015 6:10 PM, Scott Robison wrote: > Since I'm not clear on whether your two or more > processes are running on the same machine accessing a local drive or on > multiple machines or over a network, keep in mind that network file systems > are notoriously bad at the things SQLite needs (locking).