fullstack-developer

Create route handlers in the app/api directory that parse requests with Zod schemas and return NextResponse objects. Use Prisma for database access and return proper HTTP status codes like 201 for creation and 400 for validation errors.

Use React Query for server state, Zustand or Context API for client state, and react-hook-form for form state. This separation avoids prop drilling and keeps components small and focused.

PostgreSQL fits relational data with complex queries and works well with Prisma for type-safe access. MongoDB suits flexible document schemas where data structures evolve frequently.

Yes, Next.js App Router supports server-side rendering, static site generation, and API routes within the same project. You choose the rendering strategy per route based on data freshness needs.

N+1 queries happen when fetching related records in a loop instead of a single joined query. Use Prisma's include option to eager-load relations and add indexes on frequently queried fields.