Database Transfer
Unanswered
Red-billed Tropicbird posted this in #help-forum
Red-billed TropicbirdOP
Hi I want transfer my NeonDB to Supabase, How do I do this. I am using Prisma as well.
1 Reply
Red-billed TropicbirdOP
This is the main file where I connect to neon:
import { neonConfig, Pool } from "@neondatabase/serverless"
import { PrismaNeon } from "@prisma/adapter-neon"
import { PrismaClient } from "@prisma/client"
import ws from "ws"
import { env } from "@/env.mjs"
neonConfig.webSocketConstructor = ws as unknown as typeof WebSocket
const connectionString = env.DATABASE_URL
const pool = new Pool({ connectionString })
const adapter = new PrismaNeon(pool)
const prismaClientSingleton = () => {
return new PrismaClient({ adapter })
}
type PrismaClientSingleton = ReturnType<typeof prismaClientSingleton>
const globalForPrisma = globalThis as unknown as {
prisma: PrismaClientSingleton | undefined
}
export const prisma = globalForPrisma.prisma ?? prismaClientSingleton()
if (env.NODE_ENV !== "production") globalForPrisma.prisma = prisma