New release of sqlite-utils, my combined CLI tool and... | Simon Willison

Simon's posts Post Back to profile

New release of sqlite-utils, my combined CLI tool and Python library for doing useful things with SQLite databases https://sqlite-utils.datasette.io/en/stable/changelog.html#v3-38

3.38 (2024-11-23)

Plugins can now reuse the implementation of the sqlite-utils memory CLI command with the new return_db=True parameter. (#643)

table.transform() now recreates indexes after transforming a table. A new sqlite_utils.db.TransformError exception is raised if these indexes cannot be recreated due to conflicting changes to the table such as a column rename. Thanks, Mat Miller. (#633)

table.search() now accepts a include_rank=True parameter, causing the resulting rows to have a rank column showing the calculated relevance score. Thanks, liunux4odoo. (#628)

Fixed an error that occurred when creating a strict table with at least one floating point column. These FLOAT columns are now correctly created as REAL as well, but only for strict tables. (#644)

Like yesterday at 22:54 | Open on fedi.simonwillison.net

No comments