💭 SQLite FTS5 Extension
━━━━━━━━━━━━━━━━━━━━━━━

!https://www.sqlite.org/fts5.html

Date: August 21, 2023

Image: https://www.sqlite.org/fts5.html </static/https://www.sqlite.org/fts5.html>

sqlite has 3 different tokenizers, porter, ascii, trigram.

These can be used with sqlite-utils.

[code]
  sqlite-utils enable-fts --tokenize porter database.db post title message tags

And with the python api.

[code]
  db = Database('database.db')
  db["post"].enable_fts(
                  ["title", "message", "tags"], create_triggers=True, tokenize="trigram"
              )
  posts = list(db["post"].search(search))

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