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.
Passing DBs Through Continuations
Hacker News (AI keywords)7 days agoTutorialThe post explains how continuation-passing style can express database operators without materializing intermediate results. Using Prela and Julia examples, it shows list transformations, relational composition, product, scan, and probe being expanded through inlining. The result is modular query code that can compile into tight columnar loops, though the author notes assumptions around JIT cost and dense primary keys.
Datasette 1.0a30 Released with Extensible "Jump to" Menu
Simon Willison's Weblog20 days agoReleaseDatasette 1.0a30 has been released, featuring a new customizable "Jump to..." menu accessible via the "/" shortcut. The menu allows users to quickly filter and navigate to databases, tables, and debug options. Developers can extend this menu with custom items using the new jump_items_sql() plugin hook.
datasette-agent 0.1a4: Start Agent Chats Instantly via the "/" Jump Menu
Simon Willison's Weblog20 days agoNew ToolSimon Willison released datasette-agent 0.1a4, leveraging the new makeJumpSections() JS plugin hook in Datasette 1.0a30. Users can now press "/" from any page to open the "Jump to" menu and instantly access a "Start a new agent chat" input box. This update streamlines database interactions, allowing users to trigger agent-led data analysis seamlessly.
datasette-agent 發布 0.1a1 版本：改進資料表權限控制
Simon Willison's Weblog30 days agoReleaseSimon Willison has released version 0.1a1 — the latest early alpha — of `datasette-agent`, an AI agent plugin for his well-known open-source data exploration…