SQL & databases — articles — Yaroslav Tsarenko

Blog · 6 posts · RSS

Articles on SQL & databases by Yaroslav Tsarenko: in-depth, with code examples and diagrams.

Latest · SQL & databases 20 June 2026

PostgreSQL Query Optimization in Node.js: From 3 Seconds to 50ms in Production

A practical playbook for hunting slow queries in a Node.js + PostgreSQL production app — how I diagnose, index and rewrite queries with EXPLAIN ANALYZE, and how to avoid the traps that turn a small fix into a scary migration.

3 min read →