💭 sqlite_utils Python library - sqlite-utils
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

!https://sqlite-utils.datasette.io/en/stable/python-api.html#full-text-search

Date: August 20, 2023

sqlite_utils Python library - sqlite-utils sqlite-utils.datasette.io

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.

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

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

NOTE
│ This post is a thought </thoughts/>. It’s a short note that I make about someone else’s content online #thoughts </tags/thoughts/>