simonw/til

FTS index is not staying up to date

simonw opened this issue · 1 comments

https://twitter.com/hamelhusain/status/1307790112101597184

I was looking through your TILs, and was trying to search for this one using your site's search engine, but couldn't find it. ( I eventually gave up and used twitter search)...

Tried the keywords debugging, Debugging, cli, etc.

Do you know why that might be?

Here's why:

til/build_database.py

Lines 93 to 94 in f27aca8

if "til_fts" not in db.table_names():
table.enable_fts(["title", "body"])

I should either create the triggers or call populate_fts() on every run.