On 13 Dec 2013, at 11:19pm, Will Parsons <varro@nodomain.invalid> wrote:
> The total_changes() function only works from a > single connexion so doesn't help here, and it appears there is no API > to access to the file change counter that's kept in an SQLite3 database. You're right. There's no good way to do it. Though I don't see why it shouldn't be added as a PRAGMA: make sure you have a lock on the file, grab those bytes from the header, unlock the file and return the value. It would be useful for those doing multi-access with caching (an onscreen copy is a cache). Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users