On Jan 9, 2008 1:12 PM, Dean Brotzel <[EMAIL PROTECTED]> wrote: > > 1) Sqlite database file access restriction: Is there a built-in or > preferred method to block other processes from writing or even accessing > a database file when its opened first by another process. I can get this > to work by having the first process to open the file issue a BEGIN > Exclusion or BEGIN Restricted but there is always a chance, that right > after I commit and go to issue another BEGIN, a 2^nd progress can grab > and hold the file. I would like for the 2^nd process to see if another > process has control of the file and warn/adapt based on that. Definitely > NO multiple writers. >
That is Absolutely the only way get that kind of 'useful' lock on windows. End of story! 2) From the documentation I see time and time again "Stay away from > NFS". Is this the NFS designed by Sun or all Network file systems in > general? I would like (1) to be satisfied for files served from the > likes of SAMBA. > Not sure but don't use any kind of file sharing just to be safe. Hope that helps
