Brief

Simon Willison has launched Datasette Apps, a new plugin for Datasette that allows users to host custom HTML and JavaScript applications within a sandboxed iframe. These applications can execute read-only SQL queries against data in Datasette, and with proper configuration, can also run write queries. The system utilizes a combination of iframe sandboxing and Content Security Policy (CSP) headers to ensure security, preventing unauthorized access to cookies, localStorage, and external HTTP requests. This feature is inspired by concepts like Claude Artifacts and aims to provide a powerful way to integrate custom frontends with relational database backends. AI

Simon Willison has launched Datasette Apps, a new plugin for the Datasette data exploration tool. This plugin enables users to host interactive HTML and JavaScript applications directly within an iframe sandbox. These hosted applications can query the associated database, allowing for dynamic data interaction and analysis. AI

Simon Willison has released several alpha versions of his Datasette projects, focusing on enhanced user permissions and data manipulation capabilities. Datasette-acl 0.6a0 expands resource sharing beyond tables, while Datasette 1.0a34 introduces row insertion, editing, and deletion directly within the interface. Datasette Apps 0.1a3 and 0.1a2 refine app creation permissions and functionality, and Datasette Agent 0.3a0 adds a new `execute_write_sql` tool for user-approved database modifications, with options for root and unsafe modes. AI