Hi, I know I can do this per connection, however how can I have it set to default? Does this need to be compiled into python?
On Tue, Sep 22, 2015 at 2:04 PM, Ryan Stuart <ryan.stuart...@gmail.com> wrote: > On Thu, Sep 17, 2015 at 2:24 PM, sol433tt <sol43...@gmail.com> 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 you like using the execute method on a > connection as per the documentation ( > https://docs.python.org/2/library/sqlite3.html#sqlite3.Connection.execute). > For information on the specific PRAGMA option you need, see > https://www.sqlite.org/pragma.html#pragma_locking_mode. I can't see any > mention of it being a compile time PRAGMA. > > Cheers > > >> >> There is some performance to be gained. I have a number of python >> scripts, and don't want to alter the pragma statement for every script. >> This computer never writes to the databases. >> >> thank you >> >> -- >> https://mail.python.org/mailman/listinfo/python-list >> >> > > > -- > Ryan Stuart, B.Eng > Software Engineer > > W: http://www.kapiche.com/ > M: +61-431-299-036 >
-- https://mail.python.org/mailman/listinfo/python-list
