Here's my thought on sqlite_utils Python library - sqlite-utils

sqlite-utils is primarily a cli tool for sqlite operations such as enabling full text search, and executing searches, but it also has a nice python api that is exposed and pretty straightforward to use.

from sqlite_utils import Database
db = Database("database.db")
db["post"].enable_fts(["title", "message", "tags])

This returns a generator object that you can iterate over the row objects with.

This post was a thought by Waylon Walker see all my thoughts at