Datasette and Datasette Publish
summary
A toolchain converts CSVs into SQLite files, deploys them as browseable sites and JSON APIs, and demonstrably handles big datasets like 190,000 trees and 39,000 polar-bear rows. It uses SQLite + Spatialite for fast spatial queries, returns time zone lookups in about 88 ms lookup, and supports plugins, full‑text search, and named-parameter queries. The web app Datasette serves read-only DBs; Datasette Publish uploads CSVs to Zeit Now under users’ accounts via OAuth so deployments live in users’ accounts.
AI-written summary · about
chapters (10)
- 0:00Datasette introduction
- 1:07Read-only to useful tools
- 2:52Tree database with CSV
- 4:20Publishing datasets online
- 6:08Time zone API with spatial queries
- 9:00Datasette plugins for visualization
- 10:29Data journalism use case
- 12:12Low-maintenance side project
- 13:15Building Owls Near Me
- 13:56Launching Make Near Me
related talks
02h 46mData analysis with SQLite and Python
24mBuild your own data warehouse for personal analytics with SQLite and Datasette
23mFANTASTIC DATABASES AND WHERE TO FIND THEM
30mUse SQLite in production
43mVersioning, Syncing & Streaming Large Datasets Using DAT + Node
44mWriting a Database in Scala.js
37mDuckDB: Crunching Data Anywhere, From Laptops to Servers
29mHow to make public data more accessible with "baked" data and DuckDB