Design: a product listing

The core idea

A product listing turns catalog records into a page a shopper can browse.

The query decides which products qualify, their order, and where the next page begins.

In this lesson

  • Decide what one card means
  • Start with one owner for the facts
  • Model products and their references
  • Derive the page from the query
  • Keep the cursor attached to its query
  • Watch the catalog change between requests
  • Give the permitted order an access path
  • Add a copy only with an update rule
  • Change the query without changing its meaning by accident

Continue reading

Pro unlocks video lessons, visual walkthroughs, full notes, diagrams, case studies, and implementations across the System Design archive.