Re: [sqlite] DB change notification hooks across process barriers

2012-11-26 Thread Simon Slavin
On 27 Nov 2012, at 5:05am, Tristan Van Berkom wrote: > Now what I'd like to do additionally is notify clients > of changes without the IPC, relying only on SQLite's > presumably lightweight IPC change notifications > (notifications which, I'm now discovering don't > exist...) Right. > If SQLit

Re: [sqlite] DB change notification hooks across process barriers

2012-11-26 Thread Tristan Van Berkom
On 11/27/2012 01:40 PM, Simon Slavin wrote: On 27 Nov 2012, at 3:58am, Yongil Jang wrote: What I'd done to solve this problem is reading change counter in db file header. Or watch the modification date of the database file. Right, except what I need is to know exactly which row was added

Re: [sqlite] DB change notification hooks across process barriers

2012-11-26 Thread Simon Slavin
On 27 Nov 2012, at 3:58am, Yongil Jang wrote: > What I'd done to solve this problem is reading change counter in db file > header. Or watch the modification date of the database file. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] DB change notification hooks across process barriers

2012-11-26 Thread Yongil Jang
I also have same problem. What I'd done to solve this problem is reading change counter in db file header. I just implemented a simple code that reads file header. When WAL mode is enabled, iChange variable in WAL header is used. But... this code cannot be used for update notify... 2012/11/27 T

[sqlite] DB change notification hooks across process barriers

2012-11-26 Thread Tristan Van Berkom
Hi all, I just wanted to verify this detail. As I read here, http://www.sqlite.org/c3ref/update_hook.html, the function sqlite3_update_hook() can be used to watch for row insert/update/delete changes to a DB. Now, the documentation does not mention anything about this function not working fo