I have two process writing to a single SQLite file. Id like to get an event/notification of any insert updates or deletes per table when the other process writes to the file. Whats the most efficient way to do this? E.g. Process A inserts x rows, Process B gets an event that x rows were inserted. (and the same for updates and deletes). I think it would be a combination of triggers to log any create/update/delete operations, and using the OS to watch for file changes? Questions: A. Is there a version number for the SQLite file so I can detect that another process has written to it (ignoring the current processes changes). B. Is this possible to do in a general way without editing the database schema or using triggers?