Dave Sawyer - SQLite: Gotchas and Gimmes - PyCon 2016

Speaker: Dave Sawyer

Python's sqlite module provides access to the most deployed database engine
in the world. We'll go beyond the docs to discover how to unlock the full
power of SQLite without additional libraries. We'll identify deadly
pitfalls and produce clean Pythonic code. Find out why the creators say to
think of SQLite not as a replacement for Oracle, but as a replacement for
open().

[dirrelito]

I feel this is still the best sqlite3 tutorial, 7 years later