# Blog

Notes from work and side projects, mostly about what breaks and why. Written when I have understood something well enough to explain it.

- **sheet**: 4 / 6
- **feed**: [rss](https://0xshriram.dev/feed.xml)

## 2026

1. [The ten-table join that took minutes](https://0xshriram.dev/blog/grouped-queries.md) (08-02) — Why joining independent one-to-many relations multiplies rows, and what fixed a merchant-review API.
2. [Idempotency is two mechanisms and an honest "unknown"](https://0xshriram.dev/blog/idempotency-two-mechanisms.md) (07-12) — Redis for the fast path, Postgres for the truth, and a state for the case where nobody knows what happened.

## Drafts

Being written. No links until they are done.

1. Circuit breakers when the dependency is a vendor (draft)
2. Moving rules into the database without inventing a programming language (draft)
3. XXE, SSRF and other ways a parser can betray you (draft)
4. What I got wrong in Guardian's lock release (draft)

---
Canonical: https://0xshriram.dev/blog.html