On 10 Feb 2020, at 4:26am, Rowan Worth <row...@dug.com> wrote: > See also PRAGMA data_version when it comes to polling the DB, the return > value of which changes when another process modifies the DB. IIRC the > implementation of this depends on a value in the DB header page, so it may be > sufficient to only monitor the main DB file for changes.
Theoretically, one monitors the database file for its "last change" timestamp (you might know this as the "touch timestamp"). In practise, some operating systems don't notice that this has been modified until other things have happened (directory info has been updated, storage driver has finished session, etc.). But SQlite should always see a change in the content of the file first, so use the PRAGMA or manually read those bytes from the header. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
