Prisma Patterns for Production

Prisma gives you a type-safe query builder, but structure still matters for maintainability. ### Key patterns - Organize read helpers under `lib/` and wrap them in `cache()` when the data rarely changes. - Keep writes in server actions or dedicated service modules so you can reuse validation. - Prefer `upsert` or `createMany` when batching seed data. Add logging around slow queries and surface Prisma errors with human-friendly messages in the UI.