On Sat, Dec 14, 2013 at 5:46 AM, Simon Slavin <[email protected]> wrote:
> > On 13 Dec 2013, at 11:19pm, Will Parsons <[email protected]> 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, More complicated than that: The change counter in the header does not get updated in WAL mode. > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
