Re: [sqlite] Is it possible for SQLite to notify an application connected to it of database changes?

On 24 Nov 2009, at 4:12am, Erin Drummond wrote: > Currently it finds changes by constantly polling the database What, precisely, do you poll ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Is it possible for SQLite to notify an application connected to it of database changes?

On Mon, 23 Nov 2009 23:12:12 -0500, Erin Drummond wrote: > Is it possible for an application to be notified when a trigger inside > the database is fired? I imagine you could make the trigger call a user function which notifies the application... -- J. King

[sqlite] Is it possible for SQLite to notify an application connected to it of database changes?

Hi, I am developing a p2p application (in Java) which has a SQLite database attached. I am currently using the sqlitejdbc JDBC driver for database access. Ideally, I want SQLite to notify the application whenever a change is made in the database, so it can propagate the change to other peers.