Notes
Engineering notes
Writing on software architecture, backend systems, developer tooling, and AI-assisted workflows.
N-001
September 24, 2026
The Query Got Faster—and the Result Became Wrong
A real PostgreSQL case where a convincing EXPLAIN ANALYZE led to a faster rewrite that silently changed the result—and what I now validate before accepting a query optimization.
database / performance / postgresql / testing
9 min read
N-002
September 14, 2026
Before You Add Another Index: Understand the Work Your Query Requests
How query shape, access paths, and cardinality estimates interact, and how to use execution plans to decide whether to rewrite SQL, change an index, or investigate statistics.
backend / database / performance
10 min read
N-003
July 6, 2026
When LIMIT/OFFSET Stops Working: Choosing Between Offset and Cursor Pagination
A practical look at why offset pagination becomes expensive on large result sets, where cursor pagination helps, and what trade-offs each approach brings.
backend / database / performance
7 min read
N-004
November 21, 2024
Learning by Doing: Implementing Redis Caching in a Real Project
I added Redis caching to an older project to optimize performance, reduce database load, and store the most popular posts for 24 hours. It’s a strategy used by many big companies, and here's what I learned!
caching / database / performance
2 min read
N-005
October 16, 2024
Building a Concurrent File Explorer with Go
A real-world project where I created a file explorer using Go, leveraging concurrency to improve search performance in large file systems.
concurrency / go / performance
5 min read