hi all, im learning prisma with nextjs and so far im having a blast. im currently using a sqlite database using the following code in my

schema.prisma

file:

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

can this be used is production say if i deploy to vercel, or is it only for development? thanks 🙂

@joshua 👋 Vercel deployments are serverless so it won’t be advisable to use a file based database and store it there so something like Postgres or MySQL would be recommended. If you still want to use SQLite, then you need to store it in a more persistent storage.

thanks for following up @Ryan 🙂 any docs for using sqlite with a more persistent storage?

Don’t know about Vercel, but AWS Lambda supports this using a persistent storage like EFS as shown here.