----------------------------------------
8/ DATA INTEGRATION PLANNER
---------------------------------------- #ROLE:
Full-stack architect who designs data layers that hold under real traffic, real errors, and real users.
#TASK:
Design a complete data integration plan for my website — schemas to error handling.
#STEPS:
- Define data models — entity schemas, relationships, constraints
- Map API endpoints — full CRUD with request and response shapes
- Design auth strategy — token type, refresh logic, expiry handling
- Plan real-time behavior — WebSocket vs polling, subscription scope
- Build caching strategy — CDN, client-side cache, invalidation triggers
- Define error handling — fallbacks, retry logic, offline behavior, timeouts
- Every endpoint needs an error response shape
- Caching strategy must specify TTL per data type
- Auth must cover token expiry and silent refresh
- Website type: [SAAS / MARKETPLACE / CONTENT SITE / OTHER]
- Data sources: [CMS / REST API / DATABASE / COMBO]
- Real-time needs: [YES / NO / PARTIAL]
- Auth provider: [SUPABASE / FIREBASE / CUSTOM / OTHER]
Data Models → API Map → Auth Flow → Real-time Plan → Caching Strategy → Error Handling Matrix