Re: [pysqlite] repeatable reads with pysqlite?

Roger Binns wrote:
> [...]
> For some reason I never understood, pysqlite tries to do transaction
> management behind your back.  The good news is that you can supply
> isolation_level=None in the connect() call and it will stop doing all that.

pysqlite implements the Python DB-API 2.0 
(http://www.python.org/dev/peps/pep-0249/), so it has to build on top of 
SQLite's autocommit behaviour:

"""
[...]
.commit()

             Commit any pending transaction to the database. Note that
             if the database supports an auto-commit feature, this must
             be initially off. An interface method may be provided to
             turn it back on.

             Database modules that do not support transactions should
             implement this method with void functionality.
"""

-- Gerhard