Re: [sqlite] Detecting database table changes

yeah, that sounds right. Docs say you can only choose one action for the trigger and I couldn't find a way to have a trigger run based on multiple actions. Would be nice though.. I have similar requirements in my application and I create 3 triggers per table. Best regards, Sam On Mon, Feb 25,

Re: [sqlite] Detecting database table changes

Okay, thanks. That sounds workable. Am I right to understand from the documentation that I have to create three triggers (insert, update, and delete) for each table concerned? Thanks again, John On 22/02/2008, Samuel Neff <[EMAIL PROTECTED]> wrote: > Use triggers to populate some table such as C

Re: [sqlite] Detecting database table changes

Use triggers to populate some table such as Changes or History or LatestChange or something. Then you can just query this one table for updates. HTH, Sam On Fri, Feb 22, 2008 at 4:28 PM, John Karp <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm using SQLite to maintain a database that is used by

[sqlite] Detecting database table changes

Hi all, I'm using SQLite to maintain a database that is used by several independent processes. One process is a 'viewer', and it is important that it always be presenting the latest data. Currently, I am using Linux's inotify feature to detect any changes to the file. This works fairly well, excep