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

On 24 Nov 2009, at 6:17pm, Erin Drummond wrote: >> What, precisely, do you poll ? > A few mutually exclusive tables in the database to check for changes. Depending on what you care about, you might find it easier to check PRAGMA count_changes either instead of what you currently poll, or as

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

> if your application is the one making changes, can't it just notify itself at > the same time? Actually, come to think of it, it probably could. *facepalms self*. The application is going to expose a web interface which the user interacts with (this is how the database gets changed in the first

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 anapplicationconnected to it of database changes?

Erin Drummond wrote: > @Igor: I think you misunderstood. I only have one connection to the > database (provided by the JDBC driver). I only care about and use that > one connection (no other applications access the database). I was > wondering if database trigger could be used to notify the

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

Ok, thankyou for your replies @Igor: I think you misunderstood. I only have one connection to the database (provided by the JDBC driver). I only care about and use that one connection (no other applications access the database). I was wondering if database trigger could be used to notify the

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

Erin Drummond 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

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.

Re: [sqlite] Is this possible in SQLite?

John O'Neill wrote: Hi Dennis, Thanks for the reply. In the original "INSERT" commands, my intention was to update a field in the columns as they were being copied to the new table. Sorry, I didn't mean just "SELECT ... WHERE id=1" as the only condition...I'd like to select those items and

RE: [sqlite] Is this possible in SQLite?

O'Neill [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 3:48 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Is this possible in SQLite? Hi Dennis, Thanks for the reply. In the original "INSERT" commands, my intention was to update a field in the columns as they were be

RE: [sqlite] Is this possible in SQLite?

I guess this question is can I combine an UPDATE...SET with an INSERT...SELECT command? Thanks, John -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 4:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is this possible in SQLite? John O'

Re: [sqlite] Is this possible in SQLite?

John O'Neill wrote: Hello all, I have a fairly simple DB with two tables. I'm trying to combine a SELECT and UPDATE command, if it is possible: CREATE TABLE a (id PRIMARY KEY, data INT); CREATE TABLE b (id INT, data INT); INSERT INTO a VALUES( 1, 100 ); INSERT INTO b VALUES( 1, 101 ); INSERT

Re: [sqlite] Is this possible in SQLite?

> Is there a way to do the following: > > INSERT INTO acopy SELECT * FROM a WHERE id = 1 ( SET id = some value X ); > INSERT INTO bcopy SELECT * FROM b WHERE id = 1 ( SET id = X ); http://www.sqlite.org/lang_insert.html sql-statement ::= INSERT [OR conflict-algorithm] INTO

[sqlite] Is this possible in SQLite?

Hello all, I have a fairly simple DB with two tables. I'm trying to combine a SELECT and UPDATE command, if it is possible: CREATE TABLE a (id PRIMARY KEY, data INT); CREATE TABLE b (id INT, data INT); INSERT INTO a VALUES( 1, 100 ); INSERT INTO b VALUES( 1, 101 ); INSERT INTO b VALUES( 1,