Mapping SQLite Result Columns Back to Their Source table.column
Simon Willison's Weblog7 hours 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)7 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)10 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 Weblog16 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 Weblog17 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-fixtures 0.1a0 Released
Simon Willison's Weblog20 days agoReleaseSimon Willison announced the release of datasette-fixtures 0.1a0, a new plugin designed to simplify plugin testing. It utilizes the new `datasette.fixtures.populate_fixture_database(conn)` helper introduced in Datasette 1.0a30. Developers can quickly test this functionality using `uvx` to generate mock database tables and retrieve sample JSON data without a full manual installation.
Datasette Agent: An Extensible AI Assistant for Datasette★ 70
Simon Willison's Weblog23 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 Weblog24 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 Weblog25 days agoReleaseThe Datasette plugin `datasette-llm`, maintained by well-known open-source developer Simon Willison, has released version 0.1a8 today. Datasette is an…
Turso Cloud 正式加入 Vercel Marketplace，簡化 Edge 數據庫整合流程
Vercel Changelog359 days agoReleaseDistributed SQLite database service Turso Cloud has officially announced its addition to the Vercel Marketplace. This partnership brings a more seamless…