On 12 Sep 2011, at 5:08am, Akash Agrawal wrote: > I'd like to be able to tell whether a SQLite database file has been updated > in any way. How would I go about implementing that? > > I find about some file change counter but how i will get the value of file > change counter through C program
<http://www.sqlite.org/c3ref/total_changes.html> int sqlite3_total_changes(sqlite3*); My understanding (which might be wrong) is that this count includes all changes made by all connections to that database: not only changes made using your connection but also chances made by another computer, process, or thread. Actually it might be worth clarifying the text on that page to state that explicitly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
