27th November 2025
Research
Datasette 1.0a20 SQL Permissions System: Architecture Review
— A comprehensive architecture review of Datasette's new SQL-based permissions system (introduced in v1.0a20) finds that transitioning from a callback-driven model to SQL query resolution greatly improves scalability for large deployments. The redesigned system efficiently checks access by evaluating compiled permission rules through internal catalog tables, substantially reducing processing overhead compared to the multiplicative N x M callback pattern.
Recent articles
- Claude's new system prompt really doesn't want to reproduce song lyrics - 2nd September 2026
- Claude Fable 5.1 made me a really nice animated pelican - 1st September 2026
- Understanding ChatGPT Work - 30th August 2026