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 Tristan Van Berkom <[email protected]> > Hi all, > I just wanted to verify this detail. > > As I read here, > http://www.sqlite.org/c3ref/**update_hook.html<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 for modifications which were made by > a separate process, however grepping the web shows a few > warnings about this function. > > This one is over 2 years old but very detailed: > > http://www.mail-archive.com/**[email protected]/**msg53058.html<http://www.mail-archive.com/[email protected]/msg53058.html> > > Is this still true ? Or has this been fixed in the past 2 years ? > > What is the preferred way of receiving change notifications from > the SQLite connection ? > > If it's really the case that sqlite3_update_hook() does not > work across separate connections/processes, could that please > be noted in the documentation ? A simple note there could save > people valuable time in experimentation. > > Best Regards, > -Tristan > ______________________________**_________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
