Re: [sqlite] Sharing an SQLite database (using whole-file locking) over OpenAFS (Andrew File System)

On 13 Apr 2010, at 5:19am, Max Vlasov wrote: > On Tue, Apr 13, 2010 at 3:46 AM, Simon Slavin wrote: > >> >> Does SQLite actually use byte-range locking ? I thought it always locked >> the entire file. >> >> > Simon, I think it's about the way sqlite implements

Re: [sqlite] Sharing an SQLite database (using whole-file locking) over OpenAFS (Andrew File System)

On Tue, Apr 13, 2010 at 3:46 AM, Simon Slavin wrote: > > Does SQLite actually use byte-range locking ? I thought it always locked > the entire file. > > Simon, I think it's about the way sqlite implements different locks, a quote from os.h ** A SHARED_LOCK is obtained by

Re: [sqlite] Sharing an SQLite database (using whole-file locking) over OpenAFS (Andrew File System)

On 13 Apr 2010, at 12:28am, Brandon Simmons wrote: > On the OpenAFS mailing list, I was told that this might be problematic > because of the lack of support for byte-range locking in OpenAFS, but > that... Does SQLite actually use byte-range locking ? I thought it always locked the entire

[sqlite] Sharing an SQLite database (using whole-file locking) over OpenAFS (Andrew File System)

To begin, I have read the FAQ and understand that SQLite wasn't designed to be used over a network, accept all responsibility for data loss, zombie armageddon, etc... That said I am trying to determine if a bunch of sqlite DBs can be successfully shared over the network using AFS (as an