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

Reply via email to