Why our API latency dropped 40% after one index change
A walkthrough of how we found and fixed a silent N+1 query hiding in a reporting endpoint.
notes from the software industry
Shipping software,
Shipping software,
one honest changelog at a time.
Engineering deep-dives, architecture decisions, and lessons from real production systems — written by people who actually push the commits.
$ tail -f devlog.log
[08:14] new post: "Why our API latency dropped 40%"
[Yesterday] new post: "Postgres indexing, revisited"
[3d ago] new post: "On-call without the burnout"
$ _
Latest entries
View all →
#a3f19c
#7e2d0b
Angular + .NET: a pragmatic project structure
The folder layout, module boundaries, and API conventions that scale past the first MVP.
#c910f4
On-call without the burnout: a rotation that actually works
How small teams can run reliable on-call without anyone dreading their week.
#f10a2e
Freelancing as a developer: pricing your first project
A practical framework for scoping and quoting client work without underselling yourself.
Browse by topic
32 posts
Backend
21 posts
Frontend
14 posts
DevOps
9 posts