💬 观点Simon Willison
sqlite-utils 4.0rc2, mostly written by Claude Fable — Simon Willison used Claude Fable to fix
Simon Willison used Claude Fable to fix critical bugs in sqlite-utils 4.0, costing $149.25.
2026-07-05原文
本文为要点摘要，完整细节以原文为准。
🧭 一图看懂
由原文自动提炼 · 以原文为准点击任一分支，查看这一点的一句话解读
sqlite-utils 4.0rc2 由 Claude…
Simon Willison 用 Claude Fable 审查 4.0 稳定版，发现 5 个发布阻塞问题
- 最严重：delete_where() 不提交并污染连接导致…
- 37 个提示、34 次提交、+1321 -190 行、涉及…
⚙️ 流程拆解
STEP 1提示 Fable 审查 4.0 稳定版
STEP 2Fable 报告 5 个发布阻塞问题
STEP 3逐项修复并改进设计
STEP 4GPT-5.5 二次审查发现新问题
STEP 5Fable 确认并修复
STEP 6估算成本并发布 4.0rc2
🔗 涉及的概念与玩家
- sqlite-utils产品
- Claude Fable模型
- Simon Willison人物
- GPT-5.5模型
- Claude Code产品
- AgentsView产品
- SQLite产品
- Simon Willison—开发→sqlite-utils
- Claude Fable—修复→sqlite-utils
- GPT-5.5—审查→Claude Fable
- Claude Code—运行→Claude Fable
- AgentsView—估算成本→Claude Fable
- sqlite-utils—封装→SQLite
- Claude Fable identified a data-loss bug:
delete_where()never commits, poisoning the connection so subsequent writes are lost. This would have been a major release blocker. - After 37 prompts and 34 commits, the agent helped redesign transaction handling: every write method now auto-commits, and
db.atomic()groups operations. This simplifies the API and prevents silent failures. - A cross-model review (GPT-5.5 checking Claude's work) found two subtle issues:
db.query()auto-committed writes before validating the statement, andINSERT ... RETURNINGonly committed after full iteration. This shows the value of adversarial review between models.
原文：sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) · 作者 Simon Willison
🕸 顺着图谱继续读
- sqlite-utils 4.0rc2 — Simon Willison 用 AI 辅助开发 sqlite2026-07-05 · 共同涉及 sqlite-utils、Simon Willison、Claude Fable
- sqlite-utils 4.0rc3 — sqlite2026-07-06 · 共同涉及 sqlite-utils、SQLite、Simon Willison
- github-to-sqlite 2.9.1 — Simon Willison 发布 github2026-09-11 · 共同涉及 Simon Willison、sqlite-utils、SQLite
- sqlite-utils 4.2.1 — sqlite2026-08-13 · 共同涉及 sqlite-utils、Simon Willison、SQLite