Datasette for search
Datasette automatically detects tables which have been configured for full-text search and adds a search box which can be used by human site users or accessed from the JSON or CSV APIs.
The sqlite-utils command-line tool can be used to enable full-text search on a specific set of columns for a table:
% sqlite-utils enable-fts mydb.db documents title summary
You can configure search directly within the Datasette interface by installing the datasette-configure-fts plugin.