Re: [sqlite] Concurrency with writer and read-only processes

On Fri, 15 Sep 2006 17:29:13 -0400, you wrote: Hi Liam >I have a database that has one writer which runs once a day, and >potentially many readers running whenever someone wants some >information. I am trying to understand concurrency in sqlite3 so that I do a daily Job too in my programm. It

Re: [sqlite] Concurrency with writer and read-only processes

Liam Healy wrote: I have a database that has one writer which runs once a day, and potentially many readers running whenever someone wants some information. I am trying to understand concurrency in sqlite3 so that I can have the writer run each day, regardless of whether a reader is already

Re: [sqlite] Concurrency with writer and read-only processes

SQLite databases are protected like a big reader-writer lock: there is no way read while you are writing. "BEGIN IMMEDIATE" simply changes when it takes the write lock, and won't affect this. On 9/15/06, Liam Healy <[EMAIL PROTECTED]> wrote: I have a database that has one writer which runs