SQLite Full-Text Search

SQLite FTS5 can index article titles, Markdown content, tags, and categories. The blog synchronizer stores those fields in a searchable index, so a request such as /?lang=en&q=reflection searches the database instead of scanning files during every HTTP request.

CREATE VIRTUAL TABLE article_search USING fts5(title, markdown, tags, categories);