Choosing Data Stores

Search beside SQL

Users full-text search product titles and filter by category. Primary catalog lives in Postgres. Would you run search in SQL only? If not, what index do you add, how does it stay updated, and which store is source of truth on conflict?

Intermediate drill question.

Write it as you would say it in the interview: assumptions, the design, tradeoffs, and what you would do next. The draft saves in this browser.

Review the lesson