Blogs
(7 articles)Thoughts on software development, technology, and building things that matter.
Distributed Systems3System Design3Backend2PostgreSQL2Apache Pinot1AWS Architecture1CDN1Fault Isolation1FinTech1Kubernetes1MLOps1Netflix1Networking1Platform1Real-Time Analytics1Reliability1
- 4 min read
Idempotency keys are harder than a unique index
Storing the key and returning early handles the easy retry. The interesting failures are concurrent duplicates, changed request bodies, and crashes between the write and the response.
FinTechSystem DesignPostgreSQLRead Article - 5 min read
SELECT FOR UPDATE SKIP LOCKED is a queue, until it isn't
Postgres makes a decent job queue for longer than most people expect. Here is what actually breaks first, and the specific throughput at which it stops being the right answer.
PostgreSQLBackendSystem DesignRead Article