Re: [sqlite] Auto-detection of database change in multi-process environment

2007-02-03 Thread John Stanton
A trigger updating a time modified entry in an Sqlite table would do the job. [EMAIL PROTECTED] wrote: If you are just looking for a simple detection, a process could "touch" or update a flag file, which might be empty or whatever. I have not seen the C API. I am not sure about the scope or

Re: [sqlite] Auto-detection of database change in multi-process environment

2007-02-02 Thread GBanschbach
If you are just looking for a simple detection, a process could "touch" or update a flag file, which might be empty or whatever. I have not seen the C API. I am not sure about the scope or effort. But, there could be other methods. One might be to "mark" records with pending / changed transa

Re: [sqlite] Auto-detection of database change in multi-process environment

2007-02-02 Thread Ken
As I see it you have only 3 options. 1. Polling. Polling on a table in sqlite or depending upon your app. You could simply check the file access modifiers to see when the last modifaction time was. 2. Set up an IPC semaphore 3. Set up a socket. David GIGUET <[EMAIL PROTECTED]> w

[sqlite] Auto-detection of database change in multi-process environment

2007-02-02 Thread David GIGUET
Hi, Iam working on the design of a multi-process architecture accessing a single database. Is there a way for one of the process to detect that another process has modified the database ? I would like to avoid regular polling of the database to check for modifications and I also would like to