---
title: "sqlite-utils 4.0rc3 发布：新增复合外键支持与大小写不敏感列名"
source: "Simon Willison 博客（Atom）"
source_tier: "t2"
url: "https://simonwillison.net/2026/Jul/6/sqlite-utils/#atom-everything"
permalink: "https://feed.astralor.com/items/itm_b437cfcb8f40c7d2ad80259f"
published: "2026-07-06T05:40:08.000Z"
score: 67
channel: "tech"
tags: ["Simon Willison","SQLite","sqlite-utils","复合外键","大小写不敏感","版本发布"]
---

# sqlite-utils 4.0rc3 发布：新增复合外键支持与大小写不敏感列名

## AI 点评

> 虽然只是候选版本，但复合外键的支持解决了长期痛点，值得所有 sqlite-utils 用户提前了解并测试迁移。特别是那些使用多列外键的数据库设计，这次更新将减少大量手动工作。

## 速览

sqlite-utils 4.0rc3 是 Simon Willison 在发布 4.0 稳定版前的最新候选版本。主要新增功能包括：支持内省和创建复合外键（对 table.foreign_keys 有微小破坏性变更），以及遵循 SQLite 的大小写不敏感列名约定。该版本借助 Claude Fable 5 和 GPT-5.5 处理了大量 issue 和 PR。

## 关键点

- sqlite-utils 4.0rc3 新增复合外键的内省与创建功能
- 对 table.foreign_keys 接口做出微小破坏性变更，需适配
- 遵循 SQLite 大小写不敏感列名约定，影响多处代码
- 借助 AI 工具（Claude Fable 5 和 GPT-5.5）加速发布流程

## 全文

Release: sqlite-utils 4.0rc3 I hoped to release sqlite-utils 4.0 stable this weekend, but as I worked through the backlog of issues and PRs with a combination of Claude Fable 5 and GPT-5.5 the changelog since rc2 kept getting bigger. The biggest new feature is support for introspecting and creating compound foreign keys - a feature that involves a subtle breaking change to table.foreign_keys and hence needed to land for the 4.0 stable release. sqlite-utils also now follows SQLite's convention for case insensitive column names, which turned out to touch a bunch of different places at once. Tags: projects, sqlite, sqlite-utils, annotated-release-notes, gpt, claude-mythos-fable

---

引用前请核对原文;本文由星际流动整理:https://feed.astralor.com/items/itm_b437cfcb8f40c7d2ad80259f