Simon Willison 11/24/2025

sqlite-utils 4.0a1 has several (minor) backwards incompatible changes

Read Original

The article details the new alpha release of sqlite-utils 4.0, a Python library and CLI tool for SQLite. It covers minor backwards incompatible changes, including a new distinction between `db.table()` and `db.view()`, support for inserting data from iterators of lists/tuples, and a fix changing the default floating point column type from FLOAT to REAL.

sqlite-utils 4.0a1 has several (minor) backwards incompatible changes

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert 2 votes
2
Container queries are rad AF!
Chris Ferdinandi 2 votes
3
Wagon’s algorithm in Python
John D. Cook 1 votes
5
Top picks — 2026 January
Paweł Grzybek 1 votes
6
In Praise of –dry-run
Henrik Warne 1 votes
8
Vibe coding your first iOS app
William Denniss 1 votes