API Pagination Low-Level Design: Cursor, Offset, and Keyset Strategies
Pagination is not optional for any endpoint that returns a list — without it, a single request can return millions […]
Pagination is not optional for any endpoint that returns a list — without it, a single request can return millions […]
Change Data Capture (CDC) streams every insert, update, and delete from a database as an ordered event log. Instead of
The saga pattern manages distributed transactions across multiple services by decomposing them into a sequence of local transactions, each publishing
Graceful Degradation — Low-Level Design Graceful degradation keeps a system functional when individual components fail, returning reduced-quality responses rather than
CDN Integration — Low-Level Design A CDN (Content Delivery Network) caches static assets and API responses at edge nodes close
Video Transcoding Pipeline — Low-Level Design A video transcoding pipeline converts uploaded video files into multiple formats and resolutions for
Image Resizing Service — Low-Level Design An image resizing service generates and serves optimized image variants (thumbnails, responsive sizes, webp)
Caching Strategy — Low-Level Design A caching strategy determines what to cache, for how long, how to invalidate stale data,
Database Sharding — Low-Level Design Database sharding horizontally partitions data across multiple database instances, each holding a subset of the
Read Replica Routing — Low-Level Design Read replica routing directs read queries to replica databases and write queries to the
Outbox Pattern — Low-Level Design The Transactional Outbox pattern ensures that database writes and message/event publishing happen atomically, without two-phase
Cursor Pagination — Low-Level Design Cursor pagination (also called keyset pagination) navigates large datasets stably and efficiently by using a
OAuth Social Login System — Low-Level Design An OAuth social login system allows users to authenticate via a third-party provider
Faceted Search System — Low-Level Design A faceted search system lets users narrow results through multiple filter dimensions simultaneously —
Soft Delete Pattern — Low-Level Design The soft delete pattern marks records as deleted without removing them from the database,