/posvyata-bot-2026 · 2026
FICE Initiation 2026 Bot
Telegram registration bot for FICE Initiation 2026: admin broadcasts, Google Sheets sync, performance tuning.
technologies
- Python
- aiogram 3
- PostgreSQL
- SQLAlchemy 2.0
- asyncpg
- Neon
- Docker
- Render
Solo project: the registration bot for FICE Initiation 2026.
— step-by-step registration with group-format validation; — profile editing; — charity-fundraising reminders (Monobank jar); — FAQ loaded from CSV and cached in memory; — admin panel: open/close registration, mass broadcasts; — Google Sheets sync.
Python 3.12, aiogram 3, PostgreSQL on Neon (serverless) via SQLAlchemy 2.0 + asyncpg, gspread, aiohttp health check, Docker, Render.
Performance: in-memory caching, asyncio.gather, a PgBouncer-tuned connection pool, broadcasts in a background task, uvloop.