De Svitlo Bot
High-reliability Telegram bot for Cherkasy residents. Real-time power outage schedule tracking.
The problem
Frequent power outages in Cherkasy. Residents had to manually check complex schedules on utility websites — slow, confusing, and inaccessible on mobile.
The solution
A Telegram bot that scrapes local utility grids on a cron schedule, parses the data, stores it in SQLite, and serves instant schedule lookups to users.
Architecture
Python backend with aiogram for async Telegram API handling. A custom parser runs every 30 minutes, extracting structured outage data. Packaged in Docker and deployed on a Hetzner VPS with UFW firewall and automated database backups.
Result
Organic growth to 500+ users without any marketing. The bot has been running autonomously for months with zero downtime.