22 okt 2017, 18:47, Simon Slavin:
I don’t know enough about Python to evaluate this, but the sqlite3
side is sound, and some readers might find it useful.
<https://remusao.github.io/posts/2017-10-21-few-tips-sqlite-perf.html>
Simon.
It is written very well. However for readers with an SQLite background
someting must still be added. The built-in sqlite3 module begins a
transaction behind the scenes as soon as a DML statement is executed.
And expects a commit to be programmed or a connection to be explicitly
closed. Or a WITH construction. From an SQLite point of view one is
better of with the Other Sqlite Wrapper (apsw).
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users