> I've got one application that writes to the database, and one that reads
> from it. When a table in the database has changed, the reading
> application needs to know that. Of course I can send a signal from the
You may be able to use sqlite_schema:
(From the FAQ)
(17) What is an SQLITE_SCHEM
Using a trigger is exactly what I have done. It works great and you get
to easily control the parameters of event.
Just register your user-defined function and create a trigger thusly.
create trigger log_report after
insert on logEvent
for each row
begin
select appLogCallback
Hi Frank,
F.W.A. van Leeuwen wrote:
I've asked this two weeks ago but no reply yet...
I've got one application that writes to the database, and one that reads
from it. When a table in the database has changed, the reading
application needs to know that. Of course I can send a signal from the
w
You could poll the database as Micah suggested. However you may get
into the locking problems that I have. When two processes attempt a
read and write at the same time, as statistically will happen using this
method, your have a LOCK failure.
A method I suggest is using a log file. When you
d" event, but it may serve
your needs.
-Micah Caldwell
>-Original Message-
>From: sqlite-users@sqlite.org
>Sent: 04/19/05 - 00:53
>To: sqlite-users@sqlite.org
>Subject: RE: [sqlite] Callback when table contents have changed
>
>I've asked this two weeks ago b
5 matches
Mail list logo