Under the hood of Canada Spends with Brendan Samek
An interview about Canada Spends, a project using Datasette, SQLite, and LLMs to make Canadian government financial data accessible and explorable.
An interview about Canada Spends, a project using Datasette, SQLite, and LLMs to make Canadian government financial data accessible and explorable.
A developer explains his automated workflow using SQL, Datasette, and Observable to generate a Substack newsletter from his blog content.
Datasette 1.0a22 release notes covering new security features, a client detection method, and developer tools for plugin authors.
Using AI coding agents to automate repetitive plugin upgrades for Datasette 1.0, running six parallel sessions.
A developer documents upgrading a Datasette plugin for the 1.0 alpha, using tools like uv and OpenAI Codex CLI, including video and notes.
Security advisory for Datasette open redirect vulnerability fixed in versions 0.65.2 and 1.0a21, including additional features.
Datasette 1.0a20 introduces a major SQL-powered permissions system overhaul, replacing function calls with SQL queries for efficient access control.
Key takeaways from Simon Willison's podcast interview on software architecture, plugins, and effectively using LLMs in development.