I ❤️ Datasette: An Open Source Multi-tool for Exploring and Publishing Data
summary
A Datasette instance is deployed to serve a weekly SQLite snapshot of Cincinnati & Hamilton County Public Library collection data, exposing bib and item tables via a read‑only SQL-in-API that returns CSV or JSON and supports named parameters and canned queries. Queries report aggregates like 1.9 million books and 1.2 million juvenile books, visualize with Vega charts, and run in production for rapid domain expert reporting and ad hoc exploration.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 0:54What is Dataset
- 1:44Datasette Presentations
- 2:22Datasette Summary
- 4:02Collection Analysis Implementation
- 6:22Item Formats
- 7:10Count of Items
- 7:49Charting
- 8:35Named Parameters
- 9:28Query Parameters
related talks
19mExploring Datasets in Positron
24mMake data central feature
24mBuilding Open Data Platforms, an Insider's Perspective
40mPyData Stack: Pure Python open source data platforms
36mOpenbytes Builds Open Dataset Standards and Schema Aiming to Bring Transformational Changes to AI by Making Open Datasets More Available and Accessible
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
11mIntroducing Dat: If Git Were Designed For Big Data
45mManaging Data & Analytics Projects Effectively