Automatically create SQLite database and run Prisma migrations in Docker for Next.js app

Question

I have a Dockerfile that builds a Next.js application using Prisma with a SQLite database. I'd like to know if there's a recommended or automated way to create the SQLite database file and run the necessary Prisma migrations directly inside the Docker container, before the Next.js app starts. What's the best practice to achieve this setup?

American black bear · Answer

For migrations someone mentioned to me to append migration command to build script inside package.json scripts:// package.json
{
  "scripts": {
    "build": "migrate-command && next build"
  }
}For sqlite file I've never used it. I suppose something similar could work. Hopefully someone else helps you with that.

Automatically create SQLite database and run Prisma migrations in Docker for Next.js app

1 Reply