Backend Engineering Insights & Deep-Dives
EndeavourOS is the Linux Distro I have always wanted
After having to resolve a bunch of issues I was facing with Manjaro - a Linux distro based in Arch Linux that I kept using for many years without the need to change it - a few days ago, the moment had finally come, and I knew it was time to search for my next distro.
PostgreSQL Indexing Deep Dive: B-Tree, BRIN, and Partial Indexes for 10M+ Rows
When a high-volume financial transaction table crosses 10 million rows, naive sequential scans cripple the entire database cluster. In this deep dive, we examine PostgreSQL execution plans using EXPLAIN (ANALYZE, BUFFERS) and demonstrate how a 45-byte partial index dropped query latency from 2,400ms to 2.2ms.
Scaling Django with Redis: Cache-Aside vs Full-Page Caching in High-Traffic Systems
Practical blueprints for handling cache stampedes, implementing probabilistic early expiration (XFetch algorithm), and managing memory eviction policies under heavy read workloads.
Zero-Downtime Database Schema Migrations with PostgreSQL & Django
Techniques for adding NOT NULL columns, altering high-cardinality foreign keys, and safely renaming tables without acquiring destructive ACCESS EXCLUSIVE locks.
Backend Running Slow? Let's Fix That.
Go concurrency, databases, deployment, docker — I handle it all, so your uptime stays solid and your system runs smooth.