sqlite-utils 4.0rc3 adds compound foreign key support
Reported by Simon Willison: sqlite-utils 4.0rc3. Analysis and context written by TickrWire.
Evolving story · 3 updatessqlite-utils 4.0 ReleaseTimeline →sqlite-utils 4.0rc3 introduces compound foreign key support and addresses numerous issues ahead of the stable 4.0 release.
- Compound foreign key support is now available in sqlite-utils 4.0rc3, enabling multi-column foreign key constraints.
- The release candidate includes fixes for a substantial backlog of issues and pull requests.
- The stable 4.0 release is expected soon, following this third release candidate.
- sqlite-utils remains a key tool for SQLite database management and automation.
The third release candidate for sqlite-utils 4.0 includes a major new feature: support for introspecting and creating compound foreign keys. This capability allows users to define and work with multiple-column foreign key constraints, a long-requested enhancement for SQLite databases. The update also resolves a backlog of issues and pull requests, with the developer noting that the changelog grew significantly since the previous release candidate.
The release candidate phase suggests the stable 4.0 version is imminent, though the developer opted to delay the final release to ensure all pending improvements were included. The changelog highlights both new functionality and bug fixes, indicating a thorough refinement process. The tool, maintained by Simon Willison, continues to evolve as a lightweight utility for managing SQLite databases programmatically.
Developers using SQLite will benefit from compound foreign key support, improving database schema flexibility.
A minor but meaningful update for SQLite users and developers.
- compound foreign key
- A foreign key constraint that references multiple columns in another table.
AI ToolsMeta AI’s new Mac app wants you to talk to your apps
How one Philadelphia school is using AI to strengthen student learning, not replace teachers - CBS News
Domain and publish date filters for Web Search on AgentCore - Amazon Web Services (AWS)
KnowledgeForge: mining gold from the ITSM ticket graveyard - Amazon Web Services (AWS)
Google launches new study tools for Students across Search and Gemini
New White House strategy clarifies military tech priorities: undersea, outer space and AI - Breaking Defense
The White House released a new strategy prioritizing military investments in artificial intelligence, space systems and undersea technologies to counter emerging threats.
AI in an iron grip: How dictatorships use artificial intelligence to strengthen their rule - theins.press
A new report examines how authoritarian governments deploy AI for surveillance, censorship, and propaganda to reinforce their power.
Stripe, OpenRouter finally strike a deal - Banking Dive
Stripe and OpenRouter have partnered to integrate Stripe's payment processing with OpenRouter's AI model aggregation platform.
Exclusive-How a Texas student blew the whistle on a rogue AI hacking attempt - The Mighty 790 KFGO
A Texas student uncovered an AI-powered hacking attempt targeting local systems, prompting a swift law enforcement response.
Student Journalists: AI Is Changing Our Work — And Not For the Better - The 74
A student journalism outlet argues that AI tools are degrading the quality and authenticity of their reporting.
Don’t mistake chatbot intelligence for consciousness - The Economist
The Economist argues that advanced chatbots lack true consciousness despite their impressive intelligence, urging caution against anthropomorphizing AI.