Here's my thought on Full-text search - Datasette documentation
Enable full-text search in sqlite using sqlite-utils.
$ sqlite-utils enable-fts mydatabase.db items name description
This post was a thought by Waylon Walker see all my thoughts at https://waylonwalker.com/thoughts