Kamugram

A three-tier fallthrough search pipeline over 16,000+ Swahili entries: local FTS5 index, live web sources, then Gemini as a last resort.

• Fallthrough pipeline checks local SQLite indexes first, queries live web sources second, and falls back to Gemini for missing definitions.
• Cut query response times by 80% with an asynchronous Redis caching layer (aiohttp).
• Containerised with Podman Compose to manage async task queues and persistent volumes.