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 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/sqlite-users@sqlite.org/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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to