SQLite. Incredibly Fast
summary
Overview of SQLite internals and practical usage patterns for mobile apps that store local state. Covers SQLite architecture and concrete techniques to configure and interact with it to maximize performance for specific use cases.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 2:53SQLite basics
- 6:22SQLite file structure
- 17:34Data write path
- 24:39Write limits and optimization
- 30:22Write-Ahead Logging mode
- 34:14Data read path and indexes
- 42:22Summary
- 43:03Q&A
related talks
19mSQLite - The most overlooked database
01h 07mSQLite
31mSQLite, the World's Most Ubiquitous Yet Little-Known Database
30mUse SQLite in production
42mSEQUEL SQL for Android Developers
53mMaxing out SQLite performance
48mSQLite – The everywhere database
01h 56mSQLite on Rails: From rails new to 50k concurrent...