Re: [sqlite] Monitoring for inserts

2007-09-11 Thread Dan Kennedy 
On Tue, 2007-09-11 at 07:49 -0700, Mike Johnston wrote:
> What is the best way to get notified a table changed?  
> I would like to monitor a table for inserts without 
> resorting to polling.  Anyway to have a trigger call 
> a 'C' function or something?

There is, but it will only be called in the process that
performed the INSERT so cannot be used for IPC.

Polling the database is often a pretty good, efficient, 
solution. Even though it seems a bit clunky. Is there a
special reason you don't want to do it?



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Monitoring for inserts

2007-09-11 Thread Mike Johnston 
What is the best way to get notified a table changed?  I would like to monitor 
a table for inserts without resorting to polling.  Anyway to have a trigger 
call a 'C' function or something?

TIA,
Mike

   
-
Yahoo! oneSearch: Finally,  mobile search that gives answers, not web links.