Search for a command to run...
Articles tagged with #sqlite
A job-search engine over 13,000 multilingual listings — structured SQL filters, FTS5 with a trigram index, title-boosted BM25, and an eight-signal scorer in PHP — built after deliberately turning down Meilisearch.
A European job search built on a snapshot of a public board, where a pipeline of heuristics and local open-source language models reads each posting in two dozen languages and turns it into structured signals — role, experience, visa sponsorship, tech stack — before a custom search engine ever ranks it.
My freshly-deployed app returned a gateway timeout while the machine was healthy and the page rendered perfectly — the problem wasn't a crash, it was a three-minute thought, and the fix was a cache that can never be wrong.