sqlite-utils 4.0rc3 发布:支持复合外键与不区分大小写列名

sqlite-utils 4.0rc3

精选理由

Simon 发布了 sqlite-utils 4.0rc3,主要加了复合外键支持,还修了一堆 issue。用上 Claude 和 GPT 帮忙,少踩不少坑。

AI 摘要

sqlite-utils 4.0rc3 是 4.0 稳定版前的第 3 个候选版本。新版本引入了对复合外键的 introspection 和创建支持,这是与 table.foreign_keys 相关的细微破坏性变更。此外,sqlite-utils 现在遵循 SQLite 处理不区分大小写列名的约定。开发者 Simon Willison 使用了 Claude Fable 5 和 GPT-5.5 来协助处理 issue 和 PR。

原文 · Simon Willison’s Weblog

sqlite-utils 4.0rc3

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