sqlite-utils 4.0rc2, mostly written by Claude Fable
打开互动全文版（逐段中英对照 + 图/公式 + 论文问答）→赞助方：Atlassian — 给你的智能体一个计划，而非提示。新的 Jira 功能为 AI 原生软件开发解锁了完整上下文。现在可以直接从 Jira 向 Claude、Cursor 或 GitHub Copilot 分配任务。了解更多
Sponsored by: Atlassian — Give your agents a plan. Not a prompt. New Jira capabilities unlock full-context for AI-native software development. Assign tasks to Claude, Cursor, or GitHub Copilot, now directly from Jira. Learn more
赞助商：Atlassian — 给你的智能体一个计划，而非提示。新的 Jira 功能为 AI 原生软件开发解锁了完整上下文。现在可以直接从 Jira 分配任务给 Claude、Cursor 或 GitHub Copilot。了解更多
Sponsored by: Atlassian — Give your agents a plan. Not a prompt. New Jira capabilities unlock full-context for AI-native software development. Assign tasks to Claude, Cursor, or GitHub Copilot, now directly from Jira. Learn more
几周前我写了关于 sqlite-utils 4.0rc1 版本的文章。由于我们的 Max 订阅中 Claude Fable 仅剩几天可用，我决定看看它能否帮助我达到一个真正让我满意的 4.0 稳定版本，因为我尽量遵循语义化版本控制，并且希望不兼容的主版本尽可能少。
I wrote about the sqlite-utils 4.0rc1 release a couple of weeks ago. Since we only have Claude Fable on our Max subscriptions for a few more days, I decided to see if it could help me get to a 4.0 stable release that I felt truly comfortable about, since I try to keep to SemVer and like my incompatible major versions to be as rare as possible.
我从这个提示开始，在 iPhone 上通过 Claude Code for web 操作：
I started with this prompt, in Claude Code for web on my iPhone:
这是它为我创建的那份初始报告。其中有一些我自己尚未遇到的**重大**问题——Fable 将其中 5 个归类为“发布阻塞问题”。以下是其中最严重的一个：
Here’s that initial report it created for me. There were some _significant_ problems that I hadn’t myself encountered yet—5 that Fable categorized as “release blockers”. Here’s the worst of the bunch:
那真是一个严重的 bug！非常庆幸我没有发布它，尽管至少它是一个可以在 4.0.1 小版本中修复的 bug，而不是一个会迫使发布 5.0 的设计缺陷。
That’s a really bad bug! Very glad I didn’t ship that, although at least it would have been a bug I could fix in a 4.0.1 point release, not a design flaw that would force a 5.0.
在 37 个提示、34 次提交以及跨越 30 个文件的 +1,321 -190 代码变更过程中，我们依次处理了全部反馈，并沿途进行了若干其他设计改进。
Over the course of 37 prompts, 34 commits and +1,321 -190 code changes over 30 separate files, we worked through the entire set of feedback in turn, making several other design improvements along the way.
编码智能体的一件奇怪事情是，像这样更困难的任务实际上提供了**更多**同时做其他事情的机会，因为智能体有时需要 10-15 分钟来处理新任务。我出去享受了半月湾的 7 月 4 日游行，偶尔从手机上查看并提示 Fable 执行下一步。
A weird thing about coding agents is that harder tasks like this one actually provide _more_ opportunity to do other things at the same time, since the agent sometimes needs 10-15 minutes to churn away on a new task. I went out to enjoy the Half Moon Bay 4th of July parade, occasionally checking in and prompting the next step for Fable from my phone.
完整细节见 PR 和这份共享记录。我切换到笔记本电脑进行最终审查，通过 GitHub 的 PR 界面进行。
Full details in the PR and this shared transcript. I switched to my laptop for the final review, which I conducted through GitHub’s PR interface.
最重要的变化与事务处理有关，这是之前 RC 版本中的标志性新特性。新的 RC 现在包含关于新事务模型的全面文档，我将在此处完整引用其引言：
The most significant changes relate to transaction handling, which was the signature new feature in the earlier RC. The new RC now includes comprehensive documentation on the new transaction model, the intro to which I’ll quote here in full:
在审查 Fable 的文档时——我发现首先审查文档编辑是构建对变更初步理解的**极好**方式——我注意到了这个细节：
In reviewing Fable’s documentation—I find that reviewing the documentation edits first is an _excellent_ way to build an initial understanding of what has changed—I spotted this detail:
我承认我此前没有考虑过 sqlite-utils 如何应对 Python 3.12 中新增的较新自动提交设置。结果发现“在这些连接上表现不同”几乎等同于整个测试套件失败，因此我与模型合作，确保这种差异不会破坏库的工作方式。
I admit I hadn’t thought about how sqlite-utils would react to the more recent autocommit setting, added in Python 3.12. It turns out “behave differently on those connections” equated to almost the entire test suite failing, so I worked with the model to ensure that this difference would not break how the library works.
我曾认为让一个模型审查另一个模型的工作有些荒谬——这感觉奇怪地像迷信。但问题在于它确实有效——我已经习惯性地让 Anthropic 的最佳模型审查 OpenAI 的工作，反之亦然，因为我发现这样做经常能产生有趣的结果，很有价值。
I used to think that the idea of having one model review the work of another was somewhat absurd—it felt weirdly superstitious. The problem is _it really does work_—I’ve started habitually having Anthropic’s best model review OpenAI’s work and vice versa, because I’ve had that turn up interesting results often enough to be valuable.
我向 Codex Desktop 和 GPT-5.5 xhigh 输入了以下内容：
I prompted Codex Desktop and GPT-5.5 xhigh with the following:
这足以发现两个值得调查的问题：
Which was enough to turn up two issues worth investigating:
我将其粘贴到一个新的 Fable 会话中，该会话运行了一些实验来确认问题：
I pasted that into a fresh Fable session, which ran some experiments to confirm the problem:
这是包含修复的 PR 以及完整的 Claude Code 记录。审查这段代码帮助我更好地构建了 SQLite 事务语义边缘情况的思维模型！
Here’s the PR with the fix, and the full Claude Code transcript. Reviewing this code helped me build a better mental model of the edge cases of SQLite transaction semantics!
我将 Claude Max 订阅升级到了每月 200 美元的计划（之前是每月 100 美元），以增加我在 7 月 7 日 Fable 末日（届时连 Claude Max 订阅者也要为模型支付完整的 API 成本）之前剩余时间内的 Fable 配额。
I upgraded to the Claude Max $200/month plan (I was previously on $100/month) to increase my Fable allowance for the remaining time until the July 7th Fablepocalypse, when even Claude Max subscribers will have to pay full API cost for the model.
我很好奇，如果直接支付这些成本，我需要花多少钱。起初我以为我无法获得这些数字，因为我是通过 Claude Code for web 远程运行工作的，后来我意识到可以在现有会话中运行 AgentsView 来获取成本估算！
I was curious as to how much this would have cost me if I had been paying those costs directly. At first I thought those numbers weren’t available to me since I had run the work remotely using Claude Code for web, and then I realized I could run AgentsView inside that existing session to get that cost estimate!
Claude 学会了如何使用 session list --include-children 命令，并得出了以下结果：
Claude figured out how to use the session list --include-children command and came out with the following:
我很庆幸自己订阅了这个计划！我真应该听从自己的建议，更多地依赖使用更便宜模型的子智能体。
I’m very glad I’m on that subscription! I really should have followed my own advice and leaned more heavily into subagents with cheaper models.
以下是 claude.ai/settings/usage 目前向我显示的内容：
Here’s what claude.ai/settings/usage is showing me right now:
我现在还在进行其他几个由 Fable 驱动的大型项目，目标是在价格上涨之前，让 Fable 进度条达到 100%。
I have several other major Fable-driven projects on the go right now as well, with the goal of hitting 100% on that Fable bar just in time for the price increase.
以下是 RC 版本的完整发布说明。我让 Fable 在每次变更落地时将其添加到变更日志的“未发布”部分，并随进展进行审查。这产生了一个简洁的副作用：变更日志的提交历史充当了发布中每个变更的简明摘要。
Here are the full release notes for the RC. I had Fable add these to an “Unreleased” section of the changelog as each change landed, reviewing them as it went. This has the neat side effect that the commit history of the changelog acts as a concise summary of each of the changes that went into the release.
过去，我坚持手动编写发布说明，但老实说，这些说明比我亲自编写的更好。发布说明是一个很好的例子，说明我乐意将写作外包给智能体，因为它们需要枯燥、可预测且准确。
In the past I’ve had a policy of writing release notes by hand, but honestly these are better than I would have created myself. Release notes are a great example of writing that I’m OK to outsource to agents because they need to be boring, predictable and accurate.
发布于 2026 年 7 月 5 日凌晨 1 点 · 在 Mastodon、Bluesky、Twitter 上关注我，或订阅我的新闻通讯
Posted 5th July 2026 at 1 am · Follow me on Mastodon, Bluesky, Twitter or subscribe to my newsletter
* 与 Claude Code 团队的 Cat 和 Thariq 的炉边谈话 - 2026 年 7 月 21 日
* A Fireside Chat with Cat and Thariq from the Claude Code team - 21st July 2026
* Kimi K3，以及我们仍能从鹈鹕基准测试中学到什么 - 2026 年 7 月 16 日
* Kimi K3, and what we can still learn from the pelican benchmark - 16th July 2026
* 新的 GPT-5.6 系列：Luna、Terra、Sol - 2026 年 7 月 9 日
* The new GPT-5.6 family: Luna, Terra, Sol - 9th July 2026
这是 sqlite-utils 4.0rc2，主要由 Claude Fable 编写（花费约 149.25 美元），由 Simon Willison 发布于 2026 年 7 月 5 日。
This is sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) by Simon Willison, posted on 5th July 2026.
系列文章：sqlite-utils 新特性
Part of series New features in sqlite-utils
1. sqlite-utils 现在支持插件 - 2023 年 7 月 24 日，下午 5:06
1. sqlite-utils now supports plugins - July 24, 2023, 5:06 p.m.
2. sqlite-utils 4.0a1 有几个（次要的）不向后兼容的更改 - 2025 年 11 月 24 日，下午 2:52
2. sqlite-utils 4.0a1 has several (minor) backwards incompatible changes - Nov. 24, 2025, 2:52 p.m.
3. sqlite-utils 4.0rc1 增加了迁移和嵌套事务 - 2026 年 6 月 21 日，下午 11:35
3. sqlite-utils 4.0rc1 adds migrations and nested transactions - June 21, 2026, 11:35 p.m.
4. sqlite-utils 4.0rc2，主要由 Claude Fable 编写（花费约 149.25 美元） - 2026 年 7 月 5 日，凌晨 1 点
4. sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) - July 5, 2026, 1 a.m.
5. sqlite-utils 4.0，现在支持数据库模式迁移 - 2026 年 7 月 7 日，下午 7:32
5. sqlite-utils 4.0, now with database schema migrations - July 7, 2026, 7:32 p.m.
项目 546sqlite 481ai 2,136sqlite-utils 233annotated-release-notes 60generative-ai 1,888llms 1,855anthropic 312claude 292llm-pricing 84coding-agents 226claude-code 123agentic-engineering 58gpt 130claude-mythos-fable 30
projects 546sqlite 481ai 2,136sqlite-utils 233annotated-release-notes 60generative-ai 1,888llms 1,855anthropic 312claude 292llm-pricing 84coding-agents 226claude-code 123agentic-engineering 58gpt 130claude-mythos-fable 30
下一篇：sqlite-utils 4.0，现在支持数据库模式迁移
Next:sqlite-utils 4.0, now with database schema migrations
上一篇：让你的智能体用 shot-scraper 视频录制其工作演示
Previous:Have your agent record video demos of its work with shot-scraper video
每月赞助我 10 美元，即可获得一份精心策划的邮件摘要，涵盖本月最重要的大语言模型发展动态。
Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.