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

Reply via email to