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