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

[Simon Slavin]

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

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

[J. King]

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

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

[Erin Drummond]

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.
Currently it finds changes by constantly polling the database, however
this is not ideal as it wont scale well.
Is it possible for an application to be notified when a trigger inside
the database is fired?

Thanks,
Erin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users