Re: [sqlite] Small enhancement: BEGIN SHARED

2006-04-08 Thread Paul Bohme
[EMAIL PROTECTED] wrote: > Paul Bohme <[EMAIL PROTECTED]> wrote: > >> I have a small patch that adds "BEGIN SHARED" syntax in addition to >> IMMEDIATE and EXCLUSIVE. I have an application that requires a >> consistent view of the data across a number of individual statements. >> > > This

Re: [sqlite] Small enhancement: BEGIN SHARED

2006-04-08 Thread drh
Paul Bohme <[EMAIL PROTECTED]> wrote: > I have a small patch that adds "BEGIN SHARED" syntax in addition to > IMMEDIATE and EXCLUSIVE. I have an application that requires a > consistent view of the data across a number of individual statements. This is what plain old "BEGIN" does. OK, really

[sqlite] Small enhancement: BEGIN SHARED

2006-04-08 Thread Paul Bohme
I have a small patch that adds "BEGIN SHARED" syntax in addition to IMMEDIATE and EXCLUSIVE. I have an application that requires a consistent view of the data across a number of individual statements. What is ideal is a way to simply lock the database with a SHARED lock for the duration, but