---
id: 20260713-T0-07
title: "sqlite-utils 4.1.1发布：修复ON DELETE事务与外键冲突问题"
title_en: "sqlite-utils 4.1.1 fixes ON DELETE transaction edge case with foreign keys"
url: https://ai.daily.yangsir.net/daily/20260713-T0-07
issue_date: 2026-07-13
publish_date: 2026-07-12T20:55:30.000Z
category: release
source_name: "Simon Willison"
source_url: https://simonwillison.net/2026/Jul/12/sqlite-utils/#atom-everything
---

# sqlite-utils 4.1.1发布：修复ON DELETE事务与外键冲突问题

sqlite-utils发布了4.1.1版本，主要是修复一个边缘情况：当数据库启用了PRAGMA foreign_keys，并且在`ON DELETE`级联操作的事务中调用`table.transform()`时，工具现在会正确抛出TransactionError，避免数据不一致。这个bug是开发者在日常使用中通过Claude聊天发现的。

## English Version

**sqlite-utils 4.1.1 fixes ON DELETE transaction edge case with foreign keys**

sqlite-utils 4.1.1 is out, fixing an edge case where `table.transform()` now correctly raises a TransactionError if called during a transaction with `PRAGMA foreign_keys` enabled and an `ON DELETE` cascade. The bug was discovered by a developer during a regular chat with Claude.

---

**来源**：[Simon Willison](https://simonwillison.net/2026/Jul/12/sqlite-utils/#atom-everything)

**详情页**：https://ai.daily.yangsir.net/daily/20260713-T0-07

---

*智语观潮 · Daily — https://ai.daily.yangsir.net/llms.txt*