SQLite, an (un) known super ant [EuroPython 2021 - Talk - 2021-07-28 - Parrot [Data Science]] [Online] By María Andrea Vignau 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 License: This video is licensed under the CC BY-NC-SA 4.0 license: https://creativecommons.org/licenses/by-nc-sa/4.0/ Please see our speaker release agreement for details: https://ep2021.europython.eu/events/speaker-release-agreement/