Beginner · 2–3 weeks
Product Catalog with Search & Filters
E-commerce style catalog: products, categories, brands, price, stock. Full-text search by name/description, filter by price range and category, sort by price/rating. Admin CRUD for products.
Why this project
Search and filter APIs mirror real e-commerce backends. Discuss indexes, LIKE vs full-text search, and pagination.
Tech stack
Java 17Spring Boot 3Spring Data JPAPostgreSQLPostgreSQL full-text search
Skills demonstrated
- Dynamic queries
- Pagination
- Full-text search basics
- Inventory fields
Interview talking points
- LIKE vs PostgreSQL to_tsvector for search
- Composite index on (category_id, price)
- DTO projection for list vs detail endpoints
- Handling out-of-stock in API responses
Problem statement
E-commerce style catalog: products, categories, brands, price, stock. Full-text search by name/description, filter by price range and category, sort by price/rating. Admin CRUD for products.