Prisma ORM with Cloudflare D1/Next-on-pages
I'm transitioning my app from planetscale/prisma -> D1/Drizzle -> Cloudflare D1/prisma. Trying to set up a 'db.ts' folder which can be callable into different portions of the app to query the db. Anybody have experience setting this up? Doesn't help that there are only two examples in existence, both of which query D1 through a worker (rather than directly from the app).
This is my current code:
const adapter = new PrismaD1(
process.env.NODE_ENV === "development"
? getRequestContext().env.DB
: (process.env as any).DB
);
const db = new PrismaClient({ adapter })
and this is the old code, when using MySQL:
import { PrismaClient } from "@prisma/client"
declare global {
// eslint-disable-next-line no-var
var cachedPrisma: PrismaClient
}
let prisma: PrismaClient
if (process.env.NODE_ENV === "production") {
prisma = new PrismaClient()
} else {
if (!global.cachedPrisma) {
global.cachedPrisma = new PrismaClient()
}
prisma = global.cachedPrisma
}
export const db = prisma
Any assistance would be greatly appreciated.
This is my current code:
const adapter = new PrismaD1(
process.env.NODE_ENV === "development"
? getRequestContext().env.DB
: (process.env as any).DB
);
const db = new PrismaClient({ adapter })
and this is the old code, when using MySQL:
import { PrismaClient } from "@prisma/client"
declare global {
// eslint-disable-next-line no-var
var cachedPrisma: PrismaClient
}
let prisma: PrismaClient
if (process.env.NODE_ENV === "production") {
prisma = new PrismaClient()
} else {
if (!global.cachedPrisma) {
global.cachedPrisma = new PrismaClient()
}
prisma = global.cachedPrisma
}
export const db = prisma
Any assistance would be greatly appreciated.
