Re: [sqlite] Database sharing across processes

2012-07-07 Thread Jonathan Haws
Thanks, Pavel, for answering my questions! I am also thinking that I may want to make use of the sqlite_unlock_notify() call to ensure that if I try to write to the database and it fails to get a lock, it will pend until it is available. However, I thought that a query would pend until

Re: [sqlite] Database sharing across processes

2012-07-07 Thread Brad Hards
On Saturday 07 July 2012 01:00:01 Jonathan Haws wrote: For example, let's say I have two processes that connect to the same database file. One process wants to read from the database, but the other process is in the middle of a write. Does the first process pend on the read or not? If it

Re: [sqlite] Database sharing across processes

2012-07-07 Thread Simon Slavin
On 6 Jul 2012, at 4:00pm, Jonathan Haws jonathan.h...@sdl.usu.edu wrote: So, then what is the best way to make a query from one process pend until the database is available? For example, let's say I have two processes that connect to the same database file. One process wants to read

[sqlite] Database sharing across processes

2012-07-05 Thread Jonathan Haws
I am fairly new to database development and I am working on an embedded system where we are utilizing SQLite to manage some files and other information that is being shared between processes. What I am doing is I have the SQLite amalgamation source code that I am compiling into each binary

Re: [sqlite] Database sharing across processes

2012-07-05 Thread Pavel Ivanov
On Thu, Jul 5, 2012 at 10:54 AM, Jonathan Haws jonathan.h...@sdl.usu.edu wrote: I am fairly new to database development and I am working on an embedded system where we are utilizing SQLite to manage some files and other information that is being shared between processes. What I am doing is I