prisma-upgrade-v7-driver-adapters

npm install @prisma/adapter-mssql mssql

import { PrismaClient } from '../generated/client'
import { PrismaPg } from '@prisma/adapter-pg'
 
const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL
})
 
const prisma = new PrismaClient({ adapter })

import { PrismaClient } from '../generated/client'
import { PrismaPg } from '@prisma/adapter-pg'
 
const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL
})
 
const prisma = new PrismaClient({ adapter })

import { PrismaClient } from '../generated/client'
import { PrismaMariaDb } from '@prisma/adapter-mariadb'
 
const adapter = new PrismaMariaDb({
  host: 'localhost',
  port: 3306,
  connectionLimit: 5,
  user: process.env.MYSQL_USER,
  password: process.env.MYSQL_PASSWORD,
  database: process.env.MYSQL_DATABASE,
})
 
const prisma = new PrismaClient({ adapter })

import { PrismaClient } from '../generated/client'
import { PrismaBetterSqlite3 } from '@prisma/adapter-better-sqlite3'
 
const adapter = new PrismaBetterSqlite3({
  url: process.env.DATABASE_URL || 'file:./dev.db'
})
 
const prisma = new PrismaClient({ adapter })

import { PrismaClient } from '../generated/client'
import { PrismaNeon } from '@prisma/adapter-neon'
 
const adapter = new PrismaNeon({
  connectionString: process.env.DATABASE_URL
})
 
const prisma = new PrismaClient({ adapter })

import { PrismaClient } from '../generated/client'
import { PrismaPostgresAdapter } from '@prisma/adapter-ppg'
 
const prisma = new PrismaClient({
  adapter: new PrismaPostgresAdapter({
    connectionString: process.env.PRISMA_DIRECT_TCP_URL,
  }),
})

import { PrismaClient } from '../generated/client'
import { PrismaMssql } from '@prisma/adapter-mssql'
 
const adapter = new PrismaMssql({
  server: 'localhost',
  port: 1433,
  database: 'mydb',
  user: process.env.SQLSERVER_USER,
  password: process.env.SQLSERVER_PASSWORD,
  options: {
    encrypt: true,
    trustServerCertificate: true,
  },
})
 
const prisma = new PrismaClient({ adapter })

import { PrismaPg } from '@prisma/adapter-pg'
 
const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL,
  // Pool configuration
  max: 10,                    // Maximum connections
  idleTimeoutMillis: 30000,   // Close idle connections after 30s
  connectionTimeoutMillis: 5000, // Connection timeout (v6 default was 5s)
})

const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL,
  connectionTimeoutMillis: 5000,  // v6 used 5 second timeout
})

const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL,
  ssl: {
    rejectUnauthorized: false  // Accept self-signed certs
  }
})

const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL,
  ssl: {
    ca: fs.readFileSync('/path/to/ca-cert.pem'),
    rejectUnauthorized: true
  }
})

import { PrismaClient } from '@prisma/client'
 
const prisma = new PrismaClient({
  datasources: {
    db: { url: process.env.DATABASE_URL }
  }
})

// lib/prisma.ts
import { PrismaClient } from '../generated/client'
import { PrismaPg } from '@prisma/adapter-pg'
 
const globalForPrisma = globalThis as unknown as {
  prisma: PrismaClient | undefined
}
 
const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL!
})
 
export const prisma = globalForPrisma.prisma ?? new PrismaClient({ adapter })
 
if (process.env.NODE_ENV !== 'production') {
  globalForPrisma.prisma = prisma
}