Mark Chekhanovskiy (mchekhan) <mchek...@cisco.com> wrote: > I had been experimenting with TEMP triggers and > sqlite3_create_function() to get the notification about the table > changes. It seems to work on the same db connection within one thread. > Anyone tried doing similar stuff for two+ processes connecting to the > same db instance?
Yes, and they all failed. SQLite is not designed to be an interprocess communication mechanism. The best you can do is polling, or the processes could communicate by some means outside SQLite. > PS. I will try using shared connection tomorrow. I suppose you mean shared cache mode. This only works within a single process. And you still won't have triggers on one connection fired by changes made on another. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
