Erin Drummond <[email protected]> wrote: > 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. > Currently it finds changes by constantly polling the database, however > this is not ideal as it wont scale well.
An SQLite database connection can detect a change made to the database on another connection no better than a FILE* handle can detect an fwrite made to the same file on another FILE* handle. Which is to say, not at all. > Is it possible for an application to be notified when a trigger inside > the database is fired? Trigger is not fired on a database - it's fired on a database connection. There are plenty of interprocess communication mechanisms provided by any decent operating system. SQLite is not one of them. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
