On Fri, Jan 15, 2016 at 7:25 PM, Keith Medcalf <kmedcalf at dessus.com> wrote:
> While it is true that without further action each statement is carried out > in a separate transaction, it may very well be that the OP wants to have > what is called Repeatable-Read. The only way to obtain Repeatable-Read > between statements is to put the SELECTs in the *same* transaction, > otherwise they will see different views of the database if there was an > intervening update. Did you consider the new http://sqlite.org/c3ref/snapshot_get.html when you wrote the above? Richard, what's the use case(s) for the new experimental snapshot APIs? Thanks, --DD
