Elevator Pitch
This excellent tiny database is the most implemented in the world, and can be used on every platform. It has its own specific advantages, but many advanced techniques are ignored. I show best use in Python, and delve into isolation, concurrency, journal modes, special data types, and indexes.
Description
Outline 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