Skip to content
TopicTracker
From simonwillison.netView original ↗
TranslationTranslation

sqlite-utils 4.0rc1

sqlite-utils 4.0rc1 has been released, adding support for migrations and nested transactions.

Background

sqlite-utils is a Python command-line tool and library created by Simon Willison (a well-known web developer and data journalist) that makes it easy to create, query, and manipulate SQLite databases from the command line. SQLite is a lightweight, file-based relational database engine used by billions of devices — not a client-server database like PostgreSQL or MySQL. The 4.0 release candidate (rc1) is significant because it introduces two long-requested features: **migrations** (a formal system for evolving a database schema over time without losing existing data) and **nested transactions** (support for SAVEPOINT, which allows rolling back part of a transaction while keeping the rest). Prior versions of sqlite-utils were more ad-hoc about schema changes. This release matters to the Python and data-tooling ecosystem because sqlite-utils is widely used by data journalists, researchers, and developers for quick data cleaning, importing CSV/JSON data into SQLite, and building lightweight data pipelines.

Related stories

  • Show HN: HtmlUnit 5.0.0 Is Available

    3.0

    HtmlUnit 5.0.0 has been released, now requiring JDK 17 as the minimum version. Key updates include major JavaScript engine improvements, full Web Crypto API support, WebSocket improvements, Web Speech API support, and updated browser profiles for Firefox 150 and Chrome/Edge 148.

  • Show HN: JsPlumb is now free for non-commercial usage

    1.5

    JsPlumb, the JavaScript library for building visual connectivity interfaces, has released a major update with a modernized API and new diagram/2D chart engines. The project is now free for non-commercial use, with packages available for React, Angular, Vue, Svelte, and vanilla JS on the public NPM registry.

  • Datasette-apps: Apps that live inside Datasette

    1.0

    Datasette-apps is a new system that allows users to bundle and install full applications within Datasette, turning it into a platform for data-driven apps. It enables developers to create self-contained packages combining SQLite databases, metadata, plugins, templates, and assets.