Re: [sqlite] Ensure a snapshot remains readable

2019-10-15 Thread Gwendal Roué
Hello Adam, You may enjoy reading this recent thread, which is exactly about the same topic: http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2019-September/086099.html The crux of your issue is that sqlite3_snapshot_get() is not involved in transaction management at all. It

Re: [sqlite] Ensure a snapshot remains readable

2019-10-13 Thread Keith Medcalf
On Sunday, 13 October, 2019 15:23, Adam Levy wrote: >My application requires a way to build a "pending state" in the database >while allowing users to query data from both the "official state" and the >"pending state". I am achieving this using sessions and snapshots. SQLite3 does not do

Re: [sqlite] Ensure a snapshot remains readable

2019-10-13 Thread Simon Slavin
On 13 Oct 2019, at 10:23pm, Adam Levy wrote: > My application requires a way to build a "pending state" in the database > while allowing users to query data from both the "official state" and the > "pending state". I am achieving this using sessions and snapshots. You are depending on finicky

[sqlite] Ensure a snapshot remains readable

2019-10-13 Thread Adam Levy
My application requires a way to build a "pending state" in the database while allowing users to query data from both the "official state" and the "pending state". I am achieving this using sessions and snapshots. When pending data first comes into the application, I take a snapshot of the