prisma-patterns

Topics in the source

• Prisma Patterns
• When to Activate
• Core Concepts
• ID Strategy
• Schema Defaults
• include vs select
• Transaction Form Selection
• PrismaClient Singleton

Production patterns and non-obvious traps for Prisma ORM in TypeScript backends. Check your version before applying patterns. The Prisma API surface has evolved across major releases: bash npx prisma --version Notable API differences across versions: - relationJoins can load relations via JOIN rather than separate queries, but may cause row explosion on large 1:N relations or deep include — benchmark both approaches - omit field modifier and prisma.$extends Client Extensions API were added - Newer installs: the package may be named prisma instead of @prisma/client; PrismaClient may require a driver adapter (e.g. @prisma/adapter-pg); datasource.url may live in prisma.config.ts instead of schema.prisma - CLI commands (migrate dev, migrate deploy, generate) are unchanged across versions Designing or modifying Prisma schema models and relations Writing queries, transactions, or pagination logic Using updateMany, deleteMany, or any bulk operation Running or planning database migrations Deploying to serverless environments (Vercel, Lambda, Cloudflare Workers) Implementing soft delete or multi-tenant row filtering | Strategy | Use When | Avoid When | |---|---|---| | @default(cuid()) | Def

This is an excerpt. Refer to the complete source and its current requirements.