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
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
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
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
4 matches
Mail list logo