Database
19 min read
How Database Indexes Actually Work
Learn how PostgreSQL indexes work, why B-tree indexes make queries faster, how composite and partial indexes work, and how to verify whether an index actually improves your query.
Tagged articles
Articles about backend.
7 articles
Database
19 min read
Learn how PostgreSQL indexes work, why B-tree indexes make queries faster, how composite and partial indexes work, and how to verify whether an index actually improves your query.
Backend
30 min read
Learn how offset and cursor pagination work, why deep offsets become slow, how keyset pagination solves that problem, and how to design stable pagination with PostgreSQL and TypeScript.
Backend
27 min read
Learn how to evolve REST APIs safely using backward compatibility, API versions, expand-and-contract migrations, deprecation policies, and compatibility testing.
Backend
25 min read
Learn Clean Architecture in Node.js and TypeScript with domain models, use cases, ports, adapters, repositories, controllers, dependency injection, and practical trade-offs.
Backend
30 min read
Learn how to design predictable REST APIs with validation, authorization, idempotency, pagination, caching, concurrency control, rate limiting, observability, and safe evolution.
Backend
22 min read
Learn SOLID principles in TypeScript by refactoring a checkout service into smaller, testable, and easier-to-change components.
System Design
21 min read
Should you start with microservices when building a system expected to scale from 10K to 10M users? Learn why a modular monolith is often the better starting point and when microservices actually make sense.