Database Engineering5 min read
Practical PostgreSQL Query Optimization and Indexing Strategies
Techniques for reading EXPLAIN ANALYZE, choosing appropriate index types (B-Tree vs GIN), and eliminating accidental sequential scans.
Articles & Technical Insights
Practical essays on systems engineering, database indexing, bot concurrency, and software design patterns.
Backend Architecture6 min read
Architecting Large-Scale Discord Bots with Sharding and Redis
A technical guide on isolating gateway event loops, distributing memory loads via sharding, and utilizing Redis worker queues.