Help users find posts and communities.

Goal

Make discovery useful without overbuilding.

The app should support basic search and exploration, but the learner should understand why PostgreSQL search is the right first move for low traffic.

Build

• Search posts by title and body.
• Search communities by name and description.
• Explore page with active communities and recent posts.
• No-results and error states that teach users what happened.

Concepts

• Full-text search.
• Indexes and query plans.
• Ranking, precision, and recall.
• When to postpone Elasticsearch or similar systems.

Prompt stub

Add basic search using PostgreSQL full-text search.
Search posts and communities.
Add no-results, loading, and error states.
Do not introduce a dedicated search service yet.

Done means

• Users can search posts and communities.
• The app has an explore page.
• The learner can run EXPLAIN on a slow search query.
• The course explains when search starts to run hot.