SQLite, an (un) known super ant

Abstract

Juice up the world most implemented database from your python software.

Introduction: advantages, best and worst use cases.
Why this little database is amazing and where it can be used at its best.
SQLite & Python: best practices
Use of context managers, row factories, executing many operations at once and the concept of PRAGMAs
Transactions, isolation and concurrency
Transactions management in SQLite, use of WAL, Rollback and no journaling modes. Isolation levels: exclusive, immediate and deferred
Indexing
Why and why not indexing. Partial index, expression index, FTS index.
Special data types
Date & Time data, personalized data types