Writings
Thoughts, tutorials, and daily notes
- Practical PostgreSQL Query Optimization and Indexing Strategies
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.
- #PostgreSQL
- #SQL
- #Database
- #Performance
- Architecting Large-Scale Discord Bots with Sharding and Redis
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.
- #Node.js
- #Discord.js
- #Redis
- #Architecture