Re: Sqlite pragma statement "locking_mode" set to "EXCLUSIVE" by default

2015-09-22 Thread Ryan Stuart
gt; > On Tue, Sep 22, 2015 at 2:04 PM, Ryan Stuart > wrote: > >> On Thu, Sep 17, 2015 at 2:24 PM, sol433tt wrote: >> >>> I would like to have the Sqlite pragma statement "locking_mode" set to >>> "EXCLUSIVE" by default (RO database). Does thi

Re: Sqlite pragma statement "locking_mode" set to "EXCLUSIVE" by default

2015-09-22 Thread Sol T
ma statement "locking_mode" set to >> "EXCLUSIVE" by default (RO database). Does this need to be compiled in? How >> might this be achieved? >> > > You can issue any PRAGA statement you like using the execute method on a > connection as per the documentation

Re: Sqlite pragma statement "locking_mode" set to "EXCLUSIVE" by default

2015-09-21 Thread Ryan Stuart
On Thu, Sep 17, 2015 at 2:24 PM, sol433tt wrote: > I would like to have the Sqlite pragma statement "locking_mode" set to > "EXCLUSIVE" by default (RO database). Does this need to be compiled in? How > might this be achieved? > You can issue any PRAGA statement y

Re: Sqlite pragma statement "locking_mode" set to "EXCLUSIVE" by default

2015-09-21 Thread Sol T
Is anyone aware of documentation that describes how to compile various sqlite options? On Thu, Sep 17, 2015 at 2:24 PM, sol433tt wrote: > hello > > I would like to have the Sqlite pragma statement "locking_mode" set to > "EXCLUSIVE" by default (RO database).

Sqlite pragma statement "locking_mode" set to "EXCLUSIVE" by default

2015-09-17 Thread sol433tt
hello I would like to have the Sqlite pragma statement "locking_mode" set to "EXCLUSIVE" by default (RO database). Does this need to be compiled in? How might this be achieved? There is some performance to be gained. I have a number of python scripts, and don't want to a