prisma sqlite cheatsheet

prisma-sqlite-checklist.md

prisma sqlite checklist

npm install better-sqlite3
npm install prisma --save-dev
npx prisma init --datasource-provider sqlite

# update database on .env DATABASE_URL="file:./dev.db"
# create schema

# run first migration
npx prisma migrate dev --name init

# generate new model to database
npx prisma generate

# run prisma studio
npx prisma studio

use Prisma Client

// On Nextjs make sure to get client from generated file /prisma not /prisma/client
// using /prisma/client will get problem with database location
import { PrismaClient } from '@/generated/prisma';
const prisma = new PrismaClient()