PulseAugur
EN
LIVE 08:18:13

Simon Willison releases sqlite-utils 4.0 with database migrations

Simon Willison has released version 4.0 of sqlite-utils, a tool for managing SQLite databases. This major update introduces database schema migrations, allowing users to define and track sequential changes to their database structure. The new version also adds support for nested transactions and compound foreign keys. Migrations are defined in Python files and can be applied via the command line or within Python code, with the system tracking applied migrations to ensure consistency. AI

IMPACT Niche tooling improvement; minimal industry-wide impact.

RANK_REASON Release of a new version of a software tool.

Read on Simon Willison →

AI-generated summary · Google Gemini · from 2 sources. How we write summaries →

Simon Willison releases sqlite-utils 4.0 with database migrations

COVERAGE [2]

  1. Simon Willison TIER_1 English(EN) ·

    sqlite-utils 4.0, now with database schema migrations

    <p>This morning I released <a href="https://sqlite-utils.datasette.io/en/stable/changelog.html#v4-0">sqlite-utils 4.0</a>, the 124th release of that project and the first major version bump since <a href="https://sqlite-utils.datasette.io/en/stable/changelog.html#v3-0">3.0</a> in…

  2. Simon Willison TIER_1 Italiano(IT) ·

    sqlite-migrate 0.2

    <p><strong>Release:</strong> <a href="https://github.com/simonw/sqlite-migrate/releases/tag/0.2">sqlite-migrate 0.2</a></p> <p>The version that retires the library, instead implementing a compatibility shim against the new sqlite-utils 4.0 dependency.</p> <p>Tags: <a href="https:…