Skip to content
AI News HubLIVE
More
Original source1 min read

sqlite-utils 4.0rc3

Summary

Release candidate 3 of sqlite-utils 4.0 adds compound foreign key support and case-insensitive column name handling. Stable release delayed as changelog expanded.

sqlite-utils 4.0rc3
Report an error

The correction channel is not available yet. You can copy the article reference below for later.

Correction instructions
Read article

Release: sqlite-utils 4.0rc3

Simon Willison’s Weblog

Subscribe

6th July 2026

Release

sqlite-utils 4.0rc3 — Python CLI utility and library for manipulating SQLite databases

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.

Recent articles

sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) - 5th July 2026

Have your agent record video demos of its work with shot-scraper video - 30th June 2026

Porting the Moebius 0.2B image inpainting model to run in the browser with Claude Code - 22nd June 2026

This is a beat by Simon Willison, posted on 6th July 2026.

projects 544

sqlite 475

sqlite-utils 227

annotated-release-notes 58

gpt 127

claude-mythos-fable 23

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe

Disclosures

Colophon

©

2002

2003

2004

2005

2006

2007

2008

2009

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

2020

2021

2022

2023

2024

2025

2026

Key points and analysis

Article intelligence

EngineersAdvanced

Key points

  • Support for introspecting and creating compound foreign keys, with a breaking change to table.foreign_keys.
  • Adoption of SQLite's case-insensitive column name convention affecting multiple areas.
  • Development assisted by Claude Fable 5 and GPT-5.5; stable release postponed due to growing changes.

Highlights and analysis are generated automatically and may contain errors. Check the original source.