prisma

Prisma ORM patterns for efficient, scalable database operations with proper error handling and query optimization.

• Prisma Client queries and mutations
• Repository pattern for clean data access
• Transaction handling for atomic operations
• Query optimization and N+1 prevention

• Use PrismaService.main for safe client access
• Apply select to limit fetched fields
• Use include sparingly and only for needed relations
• Handle transactions with proper error handling
• Prevent N+1 queries with proper query structure
• Use repositories for complex or shared queries

1. 1.Use PrismaService.main with proper initialization checks
2. 2.Structure queries with select and include carefully
3. 3.Wrap complex operations in transactions with proper error handling
4. 4.Create repositories for shared, complex data access
5. 5.Avoid N+1 by fetching related data in one query