d1 support

[acidjazz]

I'm working on getting CloudFflare d1 support for Prisma with Nuxt Hub, I've created this issue to help track my progress, so far this version of server/utils/prisma.ts is working for me.

import { PrismaD1 } from '@prisma/adapter-d1'
import { PrismaClient } from '@prisma/client'
import type { D1Database } from '@nuxthub/core'
import type { EventHandlerRequest, H3Event } from 'h3'
import models from '../models/index'

export function useDB(event: H3Event<EventHandlerRequest>): D1Database {
  return event.context.cloudflare.env.DB as D1Database
}

let prismaClient: PrismaClient
export function usePrisma(event: H3Event<EventHandlerRequest>) {
  if (!prismaClient) {
    const adapter = new PrismaD1(useDB(event))
    prismaClient = new PrismaClient({ adapter })
  }
  return prismaClient
}

My current challenge is how to run local migrations:

• Cannot use npx prisma migrate because it doesn't harness the d1 driver
• Cannot use wrangler because it goes after the .sqlite files in .wrangler and not .data

Any suggestions/tips/etc would be appreciated, I'll update this issue as I progress

[robert-hoffmann]

bump

i like prisma, but switching to nuxt/nuxthub currently
would like to see prisma integrated with D1 too 👍

[robert-hoffmann]

hmmm...

nuxthub says this is implemented on prisma's side, and they are currently reviewing the docs for nuxt

https://volta.net/nuxt-hub/core/issues/38

I found this on cloudflare, but doesn't seem related to nuxt

https://developers.cloudflare.com/d1/tutorials/d1-and-prisma-orm

[acidjazz]

BTW a full working version of nuxt+prisma+hub+d1 can be found here https://github.com/fumeapp/bio

Please note that until this gets in the module, I had to remove it.

[robert-hoffmann]

BTW a full working version of nuxt+prisma+hub+d1 can be found here https://github.com/fumeapp/bio

Please note that until this gets in the module, I had to remove it.

Tnx, will have a look 👍