Datasette
4 mentions across all digests
Datasette is an open-source tool by Simon Willison for exploring SQLite databases via a web interface, used as a practical exercise tool in his NICAR 2026 coding agents workshop for data journalists.
What's new in pip 26.1 - lockfiles and dependency cooldowns!
Pip 26.1 introduces reproducible lockfiles and security-focused dependency cooldowns (`--uploaded-prior-to`) to enforce minimum package age in Python builds.
SQL functions in Google Sheets to fetch data from Datasette
Datasette now integrates directly with Google Sheets via SQL functions, letting users query and fetch database records into spreadsheets without writing custom scripts.
Adding a new content type to my blog-to-newsletter tool
Claude Code's agentic engineering patterns let developers rapidly add new content types to tools via structured prompts, reducing manual customization overhead.
Coding agents for data analysis
Claude Code proves practical for data analysis workflows: Simon Willison's NICAR workshop showed teams building interactive Leaflet visualizations and running SQL queries live, spending just $23 on API tokens across a 3-hour hands-on session.