fastapi

Typing hai used to kill the AI search with no_results. The culprit was MariaDB's fulltext word-length floor, not a broken prompt.

EventSource can't POST. The blog's Ask AI answers run through a plain fetch, a hand-rolled SSE parser, and one CRLF trap worth remembering.

One tiny field on the list page nearly cost a query per article. The fix is one batch IN query: two queries per page, not 1 + N.

An optional locale filter froze live search on the default locale. The culprit: bindparams validation that fires at construction, not execution.

Replace LIKE with a MariaDB FULLTEXT index, then add LLM query expansion: two layers that keep working when the index or the LLM fails.

The semantic related layer for 80 articles turned out to be a Python dict and a cosine loop, no numpy and no vector database.

Wiring env vars in Compose is only half the job; the container still needs a deliberate network path before the LLM search feature can talk to its router.

Snippet changes used to mean an edit, a commit, and a deploy wait. A whitelisted settings endpoint turns that into one PUT request.

Commit db470da adds _utc_aware at the repository so article timestamps from a naive MariaDB DATETIME are sent by Pydantic with a Z (UTC), not zoneless.