Datasette Apps: Host Custom HTML Applications Inside Datasette
Simon Willison's Weblog39 days agoNew ToolSimon Willison has launched datasette-apps, a new Datasette plugin that embeds sandboxed HTML+JavaScript applications directly inside a Datasette instance, giving each app live read-only SQL access to the underlying SQLite data. Apps run inside tightly restricted iframes using a combination of the sandbox attribute and injected Content Security Policy headers, preventing untrusted code from accessing cookies, localStorage, or external hosts. The concept originated from Willison's effort to replicate a Claude Artifacts-style experience inside Datasette Agent, before being promoted to a standalone top-level plugin.
Datasette 1.0a34
Simon Willison's Weblog41 days agoReleaseDatasette 1.0a34 ships native CRUD operations in the browser interface, letting users insert, edit, and delete rows directly from table and row pages. The feature was prompted by Datasette Agent, which recently gained SQL write support, creating an awkward asymmetry where the AI chat interface could modify data but the standard UI could not. The release moves Datasette meaningfully closer to a lightweight data-management tool rather than a read-only data publishing layer.
datasette-agent 0.3a0: Write SQL via Natural Language with User Approval
Simon Willison's Weblog43 days agoReleaseVersion 0.3a0 of datasette-agent introduces `execute_write_sql`, a new tool that translates natural language into write SQL statements and prompts the user to confirm before execution. The `datasette agent chat` terminal mode now supports these approval flows, with three new flags — `--root`, `--yes`, and `--unsafe` — to control permission levels and auto-approval. Together these additions enable fully conversational, autonomous modification of SQLite databases via an AI agent.
Mapping SQLite Result Columns Back to Their Source table.column
Simon Willison's Weblog44 days agoTutorialSimon Willison explored how to programmatically map SQLite query result columns back to their source table and column names — a capability that would let Datasette enrich query results with contextual metadata. He tasked Claude Code (Opus 4.8) with finding solutions, which surfaced three approaches: using the apsw library, calling SQLite's sqlite3_column_table_name() C function via Python ctypes, and parsing EXPLAIN bytecode output. The research is published as a GitHub README and covers the tradeoffs of each technique.
sqlite: A CGo-free port of SQLite/SQLite3
Hacker News (AI keywords)51 days agoReleaseThis project provides a CGo-free SQLite/SQLite3 implementation for Go, useful when developers want pure-Go builds and simpler cross-platform deployment. It keeps the familiar SQLite embedded database model while integrating with Go’s database/sql workflow. Recent releases upgraded SQLite, improved text/time scanning performance, added backup progress helpers, and expanded virtual table and sqlite-vec related support.
Show HN: Mnemo - local-first AI memory layer for any LLM
Hacker News (AI keywords)54 days agoNew ToolMnemo is presented as a Show HN project that provides a local-first AI memory layer for any LLM. The title indicates it is built with Rust, SQLite, and petgraph, suggesting local storage and graph-based memory relationships. Since no article body is available, details such as API design, retrieval methods, maturity, and production readiness cannot be confirmed.
datasette 1.0a31
Simon Willison's Weblog60 days agoReleaseSimon Willison released Datasette 1.0a31, a significant alpha release with two headline features: write SQL execution and stored queries. Users with the right permissions can now run database-changing queries and save queries privately or for other members of a Datasette instance. The new interface can generate templated insert, update, and delete queries for editable tables while blocking unauthorized actions such as creating tables without permission.
sqlite AGENTS.md
Simon Willison's Weblog61 days agoCommentarySQLite added an AGENTS.md file aimed at people pointing coding agents at its codebase, not at its own internal development. The file says SQLite does not accept agentic code, though it will accept agentic bug reports with reproducible test cases. The project has also split AI-generated bug reports into a new SQLite Bug Forum, where D. Richard Hipp is responding with commits.
Datasette Agent: An Extensible AI Assistant for Datasette★ 70
Simon Willison's Weblog67 days agoNew ToolSimon Willison announced the first release of Datasette Agent, merging his 'llm' Python library with Datasette. The tool provides a conversational interface to query SQLite databases, with plugin support for generating charts and running code in sandboxes. It runs efficiently on lightweight models like Gemini 3.1 Flash-Lite and supports local open-weight models via LM Studio.
datasette-agent 0.1a3 版本發布：優化 SQL 查詢檢視與截斷回應處理
Simon Willison's Weblog68 days agoReleaseSimon Willison's open-source AI assistant tool for Datasette, `datasette-agent`, has recently released version 0.1a3 in alpha. Datasette is an open-source…
Datasette 插件 datasette-llm 發布 0.1a8 版本，修復 Prompt 上下文鏈收集 Bug
Simon Willison's Weblog69 days agoReleaseThe Datasette plugin `datasette-llm`, maintained by well-known open-source developer Simon Willison, has released version 0.1a8 today. Datasette is an…