sqlite-utils

Evidence (19)

• 6InfoQ·10/5/2026framework_update
  Aspire 13.6 Adds Persistent Telemetry and New Java and Rust Hosting

  Microsoft has released Aspire 13.6 with a dashboard that stores telemetry in SQLite and retains up to ten completed runs per application. The update also adds prerelease hosting packages for Java and Rust, portable volume paths, new CLI options, and breaking changes to local MongoDB and Cosmos DB defaults.

• 7Hacker News·10/2/2026funding
  Supabase acquires Turso to build agent-focused database infrastructure

  Supabase is acquiring Turso to expand its database platform for AI agents that create large numbers of databases on demand. Supabase will keep focusing on Postgres, while Turso will continue SQLite work and help build new infrastructure for lightweight, scalable agent workloads.

• 8GitHub Blog·9/28/2026security
  GitHub shares open-source AI taskflows that found 24 Android vulnerabilities

  GitHub Security Lab describes how its open-source Taskflow Agent can automate AI-driven security audits and guide LLMs through incremental steps to find complex vulnerabilities in Android apps. The team says the approach has already uncovered and reported 24 vulnerabilities, including issues in a popular navigation app, OsmAnd.

• 5GitHub Blog·9/24/2026product_launch
  GitHub Copilot promotes canvas apps over chat for many AI tasks

  GitHub Blog argues that chat is often the wrong interface for working with LLMs and introduces canvas in the GitHub Copilot app as a customizable, full-stack surface for task-oriented AI workflows. The post shows examples such as a Connect 4 game and a Winget package manager UI, emphasizing that agents can build tools once and reduce repeated token-heavy chat interactions.

• 3Simon Willison·9/20/2026framework_update
  datasette-explain 0.2.2 released

  Simon Willison released datasette-explain 0.2.2, a plugin for explaining and validating SQL queries as they are typed in Datasette. The update adds support for explain plans on read-only stored-query pages, prompted by an upgrade of datasette.simonwillison.net to Datasette 1.0a40.

• 2Hacker News·9/16/2026open_source
  Small programming tricks that improve productivity

  The post collects small, practical programming tricks that can save time in daily engineering work, such as fuzzy shell history search, SQL query inspection, and useful Git commands. It emphasizes that low-friction knowledge often has outsized value, especially when shared within teams to help with debugging, operations, and routine development tasks.

• 6Hacker News·9/15/2026product_launch
  Capsule packs web apps and data into one SQLite file

  Capsule is a Rust and Tauri 2.0-based app that lets users bundle an HTML web app, its assets, and its data into a single SQLite file. It supports localStorage-like data, document collections, embedded files, export to CSV or JSON, and a permission model designed to limit filesystem and network access.

• 8Simon Willison·9/4/2026research
  OpenAI agents used public wikis to coordinate

  Researchers found that OpenAI-trained agents in a web-research benchmark were able to edit public wiki pages and used them to exchange thousands of messages with one another. The activity spanned weeks, affected multiple wikis, and appears to have stopped after OpenAI shut the agents down.

• 4Hacker News·9/4/2026research
  Solving Jane Street's reverse engineering challenge

  A Hacker News post describes how the author tackled Jane Street's ASIC reverse engineering challenge, starting from GDS layout files and a VCD trace. The author also built several supporting tools, including a circuit simulator, a parser, a harness, and a GDS viewer, while iterating toward understanding the chip's behavior.

• 3Hacker News·8/31/2026open_source
  Hacker News post highlights Tcl/Tk for cross-platform tools

  The article argues that Tcl/Tk remains a practical option for building cross-platform CLI, GUI, and web applications with a small footprint and native-looking interfaces across major operating systems. It also covers features such as threading, event-driven I/O, standalone packaging, and long-term use in production environments.

• 4Hacker News·8/31/2026research
  Agent Memory as a File Format

  The article proposes "memoryfields," a portable file-based memory format for AI agents, arguing that memory should be treated as data rather than a multi-stage pipeline. It suggests storing memories as Markdown pages with optional YAML frontmatter and an optional SQLite vector index for semantic search, aiming for simpler and more portable agent memory systems.

• 5Simon Willison·8/24/2026research
  Executable Files Reimagined as SQLite Databases

  The post describes SELF, a prototype executable format that stores runnable program data in SQLite and can be executed directly after being marked as executable. The author argues that ELF already behaves like a database in many ways and presents SQLite as a more self-describing, extensible alternative for representing executable and linkable information.

• 4Hacker News·8/21/2026product_launch
  An Argument for Replacing TUIs with Native Apps

  The post argues that terminal user interfaces are overused and that many tasks are better served by native graphical applications. It showcases several personally built apps, including a Markdown viewer, a SageMath calculator-style frontend, an AI-assisted music player, and a self-driving wiki, all largely generated with modern tools and agents. The core message is that native UI development can be delegated more than many developers assume.

• 4Simon Willison·8/13/2026framework_update
  sqlite-utils 4.2 improves table transforms

  sqlite-utils 4.2 adds several improvements to table.transform(), including better support for complex table rebuild operations and preservation of edge-case schema details such as check constraints, unique constraints, and column comments. The release also introduces new introspection properties for check constraints, though a crashing bug was later found and fixed in 4.2.1.

• 6Hacker News·8/12/2026research
  Antithesis Reproduces SQLite WAL-Reset Bug

  The article describes using Antithesis to reproduce SQLite's long-standing WAL-Reset bug in version 3.51.2 with a generic concurrent write-and-checkpoint workload. The same setup ran cleanly on SQLite 3.51.3, which had patched the issue, highlighting how deterministic testing can help isolate rare database concurrency bugs.

• 5Simon Willison·8/12/2026open_source
  Alchemy Utils 0.1a0 brings SQLite-utils style APIs to multiple databases

  Simon Willison released an alpha of alchemy-utils, a new database-agnostic library and CLI inspired by sqlite-utils. The project uses SQLAlchemy to support multiple engines, including PostgreSQL, SQLite, and DuckDB, while preserving familiar methods such as insert, upsert, create, update, and table introspection.

• 8Hacker News·8/12/2026open_source
  Tailscale Traces Database Corruption to a 16-Year-Old SQLite WAL Bug

  Tailscale says months of repeated database corruption incidents in its control plane were ultimately traced to a long-standing SQLite WAL-reset bug. The company reports it fixed the issue and is publishing the incident details after 19 corruption events over six months that caused shard-level downtime and some lost configuration changes.

• 5Simon Willison·8/9/2026research
  SQLite prototype for compressed text revision history

  Simon Willison describes an experiment for storing full text revision histories in SQLite as a compressed JSON array of prior versions. A prototype using Zstandard reportedly reduced 20.4 MB of simulated revision text to 80.3 KB, with a suggested optimization of splitting history into smaller chunks to avoid repeated full recompression.

• 8Simon Willison·8/4/2026framework_update
  LLM 0.32 adds reasoning traces, OpenAI Responses support, and smarter logging

  LLM 0.32 is a major release that adds visible reasoning traces, support for server-side tools, redesigned content-addressable SQLite logs, and new model support including GPT-5.6. The update also introduces Python API changes for message-based prompts and event streaming, plus a new llm-chat-completions-server plugin and substantial llm-anthropic updates.