💭 SQLite FTS5 Extension
=======================

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

Date: August 21, 2023

![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.

``` bash
sqlite-utils enable-fts --tokenize porter database.db post title message tags
```

And with the python api.

``` python
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 [1]. It's a short note that I make
 about someone else's content online #thoughts [2]

References:
[1]: /thoughts/
[2]: /tags/thoughts/