I built an AI-personalized news bot that runs on a single SQLite file — architecture and everything that broke

I built an AI-personalized news bot that runs on a single SQLite file — architecture and everything that broke TL;DR — @futur_e_news_bot. A bilingual (EN/RU) Telegram news feed. AI removes duplicates, clusters one event into one card, translates, and tunes the feed to your reactions. Stack: aiogram, local ONNX embeddings, sqlite-vec instead of pgvector, a chain of free LLMs via OpenRouter, one worker on Fly.io. It started at ~$5/month — and broke in three interesting ways I'll walk through....