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
> 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
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
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
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
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
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
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.
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
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
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'
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
> 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
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,
14 matches
Mail list logo