Woohoo, thanks Dan! I'm going to try this very soon :-) Gwendal
On Thu, Sep 19, 2019 at 1:18 PM Dan Kennedy <danielk1...@gmail.com> wrote: > > On 19/9/62 18:13, Gwendal Roué wrote: > > Hello, > > > > I am looking at the snapshot experimental APIs, and it looks like once a > > connection has been sent to an "historical snapshot" with > > sqlite3_snapshot_open (https://www.sqlite.org/c3ref/snapshot_open.html), > > the connection can never be restored back to regular operations. > > > > Is it correct? > > I don't think so. > > If you end the transaction opened with sqlite3_snapshot_open() (by > executing a "COMMIT" or "ROLLBACK" and calling sqlite3_reset() or > sqlite3_finalize() on all active SELECT statements) then open a new > transaction, the new transaction accesses the latest database snapshot - > just as if you had never used sqlite3_snapshot_open() with the > connection at all. > > Dan. > > > > > > > Thanks is advance, > > Gwendal Roué > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users