Podo Stack

Podo Stack

Home
Notes
Archive
About
Invisible Indexes: The Safest Way to Delete an Index You're Not Sure About
MySQL 8.0's hidden indexes let you A/B test index removal in production without DDL risk
 • Ilia Gusev
AUTO_INCREMENT Is Silently Throttling Your Writes
Why MySQL's oldest ID generator becomes a bottleneck at scale and what to replace it with
 • Ilia Gusev
Your Business Logic Is Spread Across Cron, Queues, and State Flags. Temporal Kills All Three.
Durable workflows, deterministic replay, signals, retry policies, and versioning in production
 • Ilia Gusev
Denormalization: When JOINs Kill Your Read Performance
Intentional data duplication for read-heavy systems - trade-offs, patterns, and when it's actually worth it
 • Ilia Gusev
Prefix Indexes: Stop Indexing 255 Characters When 16 Is Enough
When VARCHAR(255) is in the WHERE clause but only the first 16 characters matter
 • Ilia Gusev
Tools From the Future
Dapr distributed runtime, Kargo GitOps promotion, WasmEdge vs containers, Koordinator scheduling, and OpenFeature
 • Ilia Gusev
Redis INT vs RAW Encoding: Why Your Counters Use 10x Less Memory
Inside Redis string encoding - how INT, EMBSTR, and RAW work, and what happens when you accidentally break them
 • Ilia Gusev
Partial Indexes in MySQL: The Trick PostgreSQL Doesn't Want You to Know
Emulating filtered indexes with generated columns and functional key parts - no migration required
 • Ilia Gusev

March 2026

© 2026 Ilia · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture