PostgreSQL Indexing: A Practical Guide for Backend Engineers
Choose the right PostgreSQL index: B-tree column order, partial, covering, expression, GIN and BRIN indexes, reading EXPLAIN ANALYZE, unused indexes.
Performance articles
7 articles about Performance, written from hands-on experience building and scaling production systems.
- 7 min
- 8 min
Redis Caching Strategies That Survive Production
Cache-aside, write-through and write-behind in Node.js, plus what tutorials skip: invalidation, TTL jitter, cache stampedes, hot keys and eviction.
- 5 min
Scaling Node.js: From Single Server to Handling Millions of Requests
Scale Node.js from one server to millions of requests: clustering, horizontal scaling, load balancing, Redis caching, worker threads and monitoring.
- 5 min
Why Your API Is Slow (And How to Fix It)
Diagnose and fix slow APIs: N+1 queries, missing indexes, payload bloat, connection pool exhaustion and caching, with Node.js and SQL examples.
- 14 min
Building a Modern Search System: Debouncing, Ranking, Real-Time
How to build production search: frontend debouncing, ranking algorithms, Elasticsearch fundamentals and real-time index updates with change data capture.
- 5 min
Debouncing Search in JavaScript and React: The Complete Guide
Debounce search input in JavaScript and React: debounce vs throttle, a useDebounce hook, cancelling stale requests with AbortController, and testing.
- 7 min
How I Built an SEO-First Developer Portfolio with Next.js
A blueprint for a developer portfolio that ranks for your name: static rendering, structured data, OG images, sitemaps, RSS and a content strategy.
Other topics
Backend 12System Design 11Distributed Systems 6Architecture 4Node.js 4AI Engineering 3LLM 3Redis 3Tutorial 3API Design 2Career 2CTO 2Engineering Management 2Leadership 2PostgreSQL 2Startups 2Web Development 2Caching 1CDC 1Cloud 1Consulting 1Databases 1DevOps 1Docker 1Elasticsearch 1Frontend 1Interviews 1JavaScript 1Kafka 1MCP 1Microservices 1Mobile 1Next.js 1Personal Branding 1Production 1RabbitMQ 1RAG 1React 1Search 1SEO 1SQL 1TypeScript 1