JuniperCore developer — backend, frontend, database2019 — 2025
Multipurpose Discord bot for large communities — moderation and utilities.
- Production bot at scale; to date: 1,291,495 servers, 4,928,753 users, 198M+ commands processed.
- Cut p95 query latency from 1.4 s to 18 ms (~77x) and peak database CPU from 85% to 15%: found a Seq Scan on deep history pages and season leaderboards via EXPLAIN ANALYZE, moved to keyset pagination (WHERE id < last_seen_id) and added a covering index on (server_id, created_at DESC) INCLUDE (user_id, points).
- Python
- discord.py
- PostgreSQL
- GalaxyGate