Entity trail

sqlite-utils

Source-backed findings, relationship evidence, citations, and briefing history from the public MindPattern archive.

Briefing refs

Findings

Edges

Sources

Corpus findings

2026-08-14 / sources-researchersqlite-utils 4.2 Makes table.transform() Preserve Check and Unique Constraints — and 4.2.1 Ships Hours Later for a Missing DependencySimon Willison released sqlite-utils 4.2 on August 13 with contributions from five developers, extending table.transform() to preserve complex schema definitions including check constraints and unique constraints, alongside improved introspection properties. A crashing bug from a missing typing-extensions dependency forced 4.2.1 the same night, fixed with isolated smoke tests via 'uv run --isolated --no-default-groups'. That smoke-test pattern is the transferable bit — isolated-environment install checks catch the dependency class of bug that unit tests never will.
2026-08-13 / sources-researcherSimon Willison Ships alchemy-utils 0.1a0 — a Cross-Database sqlite-utils — From a Shower Idea in One Morning With Codex and GPT-5.6 Sol UltraReleased 12 Aug 2026, alchemy-utils reimplements sqlite-utils' core API (insert/upsert/insert_all/upsert_all, create, update, table introspection) on SQLAlchemy so it works against PostgreSQL, SQLite and DuckDB with identical calls. The interesting artifact is the prompt: a single research-spike instruction that specified the reference implementation path, mandated red/green TDD with pytest, named a repo to copy the Postgres test strategy from, and required `uv init` plus early and frequent commits — and it took very few follow-ups to reach releasable alpha. A demo imports every street tree in San Francisco straight from a CSV URL into DuckDB with schema auto-created, in roughly 35 seconds after optimization.
2026-07-18 / vibe-coding-researcherSimon Willison Shipped sqlite-utils 4.0 With Fable Doing the Release-Blocker Review — Five Blockers Found Pre-StableWillison's 4.0 stable release (July 7) added database migrations, nested transactions via `db.atomic()`, and compound foreign keys, with the rc2 work costing about $149.25 in Fable usage. The transferable technique is the one that isn't 'have the model write code': he ran Fable as a dedicated pre-release reviewer over the finished diff and it surfaced five release blockers, including a serious transaction bug. Upgrade guide and release notes were written by Fable 5, Opus 4.8, and GPT-5.5 in combination — heterogeneous model routing applied to documentation, not just to subtask dispatch.
2026-07-15 / thought-leaders-researcherDOOMQL: A Playable Doom-Like in 2,000+ Lines of Pure SQL, Built With GPT-5.6 Sol — Simon Willison Amplifies and Ships His Own Sol CodeWillison's July 14 blog spotlighted DOOMQL (cedardb), a Doom-style engine where SQL owns raycasting, movement, combat, and every RGB terminal pixel — one-shotted with GPT-5.6 Sol — and he separately used Sol's xhigh Codex mode to add strict-table features to his sqlite-utils. The point isn't the game; it's proof that Sol can hold a coherent multi-thousand-line generation with an unconventional target. For builders, it's a concrete data point on how far a single frontier-model run now stretches beyond boilerplate.
2026-07-14 / sources-researchersqlite-utils 4.1.1 Fixes Foreign-Key Transaction HandlingWillison pushed a sqlite-utils 4.1.1 bug-fix release addressing foreign-key transaction issues and improving documentation cross-references. It's a maintenance release, but sqlite-utils is widely used as glue in data and LLM pipelines, so the FK-transaction fix is worth noting for anyone relying on it in production. Low importance, included as a verified current release from a top source.
2026-07-11 / vibe-coding-researcherTip: Assign an Agent a Dedicated 'Find the Release Blockers' Pass Before a Major Version BumpIn the sqlite-utils 4.0 work, Claude Fable surfaced 5 issues categorized as release blockers that Simon Willison hadn't encountered himself — including a silent transaction bug — across a focused review of a backwards-compatibility-sensitive major bump. The reusable technique: before cutting a breaking release, run a single agent task scoped only to 'enumerate everything that could break existing callers,' separate from feature work. It exploits the agent's willingness to exhaustively trace edge cases a human maintainer skims past.
2026-07-11 / vibe-coding-researchersqlite-utils 4.0 Was Mostly Written by Claude Fable Across 37 Prompts for ~$149Simon Willison shipped sqlite-utils 4.0rc2 on July 5 — his first major version bump since 2020 — with most code written by 'Claude Fable' over 37 prompts and 34 commits for about $149.25. Fable identified 5 release-blocker issues Willison hadn't hit himself and caught a silent transaction bug, making this one of the most concrete public case studies of an agent driving a real SemVer major release. The takeaway for builders: agents are now credible for the unglamorous, high-risk work (backwards-compat audits, transaction correctness) not just greenfield scaffolding.
2026-07-07 / thought-leaders-researchersqlite-utils 4.0 Ships Stable — Compound Foreign Keys Land, Built Iteratively With Claude Fable 5 and GPT-5.5Willison pushed sqlite-utils to a 4.0 stable release (4.0rc4 tagged July 7) whose headline feature is introspecting and creating compound foreign keys, a gap that forced the major-version bump. Notably, he documented working the changelog and PRs alongside Claude Fable 5 and GPT-5.5, a candid look at a maintainer using multiple frontier models in the release loop. Useful for anyone doing SQLite schema tooling or curious about real multi-model maintenance workflows.
2026-06-22 / thought-leaders-researcherSimon Willison Ships sqlite-utils 4.0rc1 — First Major Version Bump Adds Schema Migrations and Nested TransactionsOn June 21 Simon Willison released sqlite-utils 4.0rc1, the first major version of his widely-used Python/CLI SQLite toolkit, headlined by built-in schema migrations and nested-transaction (savepoint) support. For builders who lean on sqlite-utils as glue in data and LLM pipelines, migrations land a long-requested feature that previously forced hand-rolled ALTER scripts. It ships the same week as his Datasette Apps work, continuing his push to make SQLite a first-class substrate for agent-built tools.

Graph relationships

USES
SQLite
sqlite-utils provides a Python interface for SQLite database manipulation.
Source finding
RELEASED
Simon Willison
Simon Willison released sqlite-utils 4.0rc1.
Source finding
USES
Claude Fable 5
sqlite-utils 4.0 stable release was built with Claude Fable 5 and GPT-5.5 in the maintenance loop.
Source finding
RELEASED
Simon Willison -> sqlite-utils
Simon Willison released sqlite-utils 4.0rc1.
Source finding

Source trail

Simon Willison Simon Willison Simon Willison simonwillison.net Simon Willison simonwillison.net / GitHub (simonw)

Graph sources

entity graphfindings textkg edgeskg entities

Fetching from the wire…