SQLite Forum

SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows
Login
That's a much better fix than the hack I had where I would delete spare rows from that table.

I just released sqlite-utils 2.18 which adds a `sqlite-utils rebuild-fts data.db` command-line command and a `db["my_table"].rebuild_fts()` Python API method: <https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v2-18>