> What is the preferred way of receiving change notifications from > the SQLite connection ?
Just in case it helps, we also had this problem in an embedded system where constant polling of sqlite tables was expensive and what we did is: Add a directory in /tmp which every process connected to sqlite can monitor with inotify. When a process modifies a table, it writes a file named after the table name to this directory. Every process that is monitoring the directory then receives notification of the change and can decide (from the filename) if it is interested in reading the table that has changed. It's quick and dirty but it works... If more fine-grained notification is needed in your case, you could add whether the change was a delte/update/insert ( or even the whole SQL statement) in the file contents or as an extension to the filename. Regards David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
