I have a question when building npm create solid with-prisma template.

In npm run dev, prisma with url="File:./dev.db" works fine, but when you run npm run build and start it with node.output/server/index.mjs, the path is not found.
How do I specify the path at build time?

Katja (katywings)•6/2/24, 9:35 AM

I also stumbled upon this and came up with a little trick

:
https://discord.com/channels/722131463138705510/1243486537438461952/1243486985562095677

Katja (katywings)•6/2/24, 9:36 AM

P.S. if your prisma schema is in a subfolder, I recommend you to make the path relative to that subfolder

voxel8OP•6/2/24, 11:47 PM

The DATABASE_URL in .env was not read, so import dotenv from 'dotenv'
I read process.env ['DATABASE_URL'] and finally solved it. Thank you.