SQLite Forum

sqlite write performance is slower than the filesystem
The sqlite3 wrapper in Python does this automagically unless you have turned the automagic setting to "manual".  The wrapper calls this the isolation_level of the connection and is controlled by a connection property (and connect method parameter) of the same name.  How well this magic works depends on the particular version of pysqlite2 that is being used (the sqlite3 wrapper), and thus the version and release date of the version of python being used.

The sample uses the default setting so the first "insert" on the connection will begin a deferred transaction which is committed when the .commit method of the connection is called.

The .executemany method prepares the SQL statement and then binds and steps the resulting statement for each member of the list of bind parameters.