Prisma + PostgreSQL with Next.js: Setup and Best Practices

How to set up Prisma with PostgreSQL in a Next.js app — schema design, migrations, the client singleton, and patterns that avoid connection pool exhaustion.