You might also be able to watch the database file itself for changes using a platform specific mechanism. On UNIX, you could use kqueue's and on Windows a combination of FindFirstChangeNotification, FindNextChangeNotification and WaitForMultipleObjects. This would allow you to watch for database changes without polling.
Pat -----Original Message----- From: Roberto [mailto:[EMAIL PROTECTED] Sent: Friday, December 08, 2006 4:23 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] about call back of sqlite. On 08/12/06, hongsion <[EMAIL PROTECTED]> wrote: > Hi sqlite, > I want to using sqlite this way. Application A register callback > to sqlite db. And application B will modify sqlite db. I want each time > sqlite was modified by B, A is notified by callback. Is this possible in > sqlite? A and B run in different process. Thanks! > No it is not possible, you have to implement your own cross process mechanism to notify applications of changes. Another idea DRH brough up in the past, is to poll a table which stores ID's of items that have changed. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
