sqlite-utils

: sqlite-utils enable-fts mydb.db documents title summary # after subsequent writes sqlite-utils populate-fts mydb.db documents title summary # rebuild the FTS indexes sqlite-utils rebuild-fts mydb.db documents.

Doesn’t sqlite-utils does this and more, better?

If you want a more convenient way to do column reordering (and other advanced alter table operations) in SQLite my sqlite-utils CLI tool can do this: sqlite-utils transform data.db mytable \ -o id -o title -o description That will change the order of the columns in the specified table such that id, title and description come first.

A complex example from the docs: sqlite-utils transform fixtures.db roadside_attractions \ --rename pk id \ --default name Untitled \ --column-order id \ --column-order longitude \ --column-order latitude \ --drop address This addresses one of the most frequent complaints people have about SQLite - that it doesn't support a range of table alter operations beyond simple things like adding a new column.

But telling it to "Run pip install sqlite-utils" worked, so apparently they have allow-listed some domains such as PyPI.

And with tools like "make it easy to replcate" Litestream and "make it easy to use" sqlite-utils, it just becomes easier.

But telling it to "Run pip install sqlite-utils" worked, so apparently they have allow-listed some domains such as PyPI.

And with tools like "make it easy to replcate" Litestream and "make it easy to use" sqlite-utils, it just becomes easier.