api

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.