Data analysis with SQLite and Python
summary
Shows concrete workflows: use Python's sqlite3 and sqlite-utils to import CSVs (14,341 manatee records), normalize columns into foreign keys, and add ISO dates; build a searchable PEP database (429 PEPs), enable FTS-5 full‑text ranking, and publish peps.db to Vercel/Cloud Run as a live API. Demonstrates Datasette for faceting and SQL inspection and even Datasette in WebAssembly running wholly in the browser; claims performance (2.8 TB max DB, fast C JSON/FTS) and the deployments actually work.
AI-written summary · about
chapters (12)
- 0:00Welcome
- 1:06Setup
- 10:00SQLite features
- 25:08SQLite in Python
- 39:50Dataset tool
- 1:05:25Legislators database
- 1:25:36sqlite utils CLI
- 1:45:41PEPs database
- 2:05:44Publish SQLite online
- 2:17:04Advanced SQL
- 2:34:02Fun demos and real-world applications of dataset
- 2:45:26Q&A
related talks
24mBuild your own data warehouse for personal analytics with SQLite and Datasette
15mDatasette and Datasette Publish
23mFANTASTIC DATABASES AND WHERE TO FIND THEM
58mA Scientist's Guide to the Relational Data Model
29mBuilding a biological database with Python
30mUse SQLite in production
40mPyData Stack: Pure Python open source data platforms
27mUsing embedded SQL engines for plotting massive datasets on a laptop