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.