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

Reply via email to