Re: [sqlite] Callback when table contents have changed

> 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

Re: [sqlite] Callback when table contents have changed

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

Re: [sqlite] Callback when table contents have changed

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

Re: [sqlite] Callback when table contents have changed

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

RE: [sqlite] Callback when table contents have changed

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 but no reply yet

[sqlite] Callback when table contents have changed

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 writer to the reader app, but if