-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ben Harper wrote: > Is there any official way of obtaining the database modification counter?
No. The closest is the schema version which only changes when the schema changes. There is also a user version you can use in your own code. See http://www.sqlite.org/pragma.html#version > " In order to determine whether or not the database file has changed, > SQLite uses a counter in the database header (in bytes 24 through 27) > which is incremented during every change operation. " Worst case you can just manually read those bytes or check the file modification time. Other approaches include using triggers to automatically update a table with modification information that other processes can read. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkn+tWsACgkQmOOfHg372QS8pgCgs6ewBctfKytWd7aX/4pn09CK UGAAn04N8AojpCLpGmO9yNkOUUYT8UE0 =ceo5 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users