writing
Long-form deep-dives on distributed systems, databases, and backend engineering. Published on Substack — subscribe to get new posts in your inbox.
Yes, you can store JSONs in Postgres. No, you shouldn't. Well, it depends
PostgreSQL's JSON and JSONB types are powerful, but they're not a replacement for a document store.
This post breaks down the storage mechanics, indexing tradeoffs, query performance characteristics,
and the specific patterns where JSON in Postgres shines — and where it burns you.
From the Birthday Paradox to Consistent Hashing
How the classic birthday paradox leads naturally to understanding load distribution in
distributed systems, and sets the stage for Google's "Consistent Hashing with Bounded Loads."
A quick conceptual bridge between probability and systems design.
Subscribe on Substack to get notified of new posts.