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