Real-time Telegram analytics & ingestion engine
Distributed ingestion for 20K+ messages a day and 40M+ stored records. Reporting moved from PostgreSQL to ClickHouse materialized tables; the API sits behind Redis with fixed N+1 queries and rebuilt composite indexes.