search

simonw / til

Today I Learned
https://til.simonwillison.net
Apache License 2.0
1.08k stars 86 forks source link

FTS index is not staying up to date #27

Closed simonw closed 4 years ago

simonw commented 4 years ago

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?

simonw commented 4 years ago

Here's why: https://github.com/simonw/til/blob/f27aca81bf237636c35c7b4a1ddb6972813ae2df/build_database.py#L93-L94

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