> sqlite-users mailing list
View this message in context:
On Mar 16, 2010, at 5:22 AM, GeoffW wrote:
> Hello Dan
> Thanks for your useful input. To answer your questions.
>> Do you have any file-locking primitives provided by the OS?
> There are no file locking OS Primitives at all that I can use.
>> Do you have clients connecting to the
>>>> SQLITE_THREADSAFE = 0 (so I probably dont even need a file lock in
>>>> configuration I have at present ?)
>>>> However I would of course like to make SQLITE_THREADSAFE = 1 so that
>>>> multiple tasks can sa
imer: this is not my specialism, I hope it helps
>> SQLITE_THREADSAFE has effect on threads within the same
>> process (=task), especially when they use the same
>> connection. You need file locks for synchronisation between
>> different processes. If the file
processes. If the filesystem doesn't provide them,
> you could use the dot lockfile paradigm, which seems to be
> associated with SQLITE_ENABLE_LOCKING_STYLE.
>>Thanks for any guidance
> ( Kees Nuyt
On Fri, 12 Mar 2010 02:22:31 -0800 (PST), GeoffW
>Now I have got a half ported version of Sqlite up and running on MQX I cant
>put off any longer the question of file locking and how I tackle that ? For
>the moment i had made the xLock() and xUnlock() the
Sent from the SQLite mailing list archive at Nabble.com.
sqlite-users mailing list
Mail list logo