Problem
Design a product catalog with hierarchical categories and direct product memberships
- Navigate category trees via direct-children queries to avoid recursive joins
- Serve stable-order pagination for high-traffic category shelves
- Atomically validate acyclicity during category reparenting
Key Test Points
- Junction table composite indexes
- Adjacency list with cycle validation
- Cache slices with targeted invalidation
Spot an issue or have a suggestion?