Prisma 7 + SQLite via better-sqlite3 adapter: working versions (tested 2026-10-15)

{
  "name": "prisma-sqlite-adapter",
  "private": true,
  "type": "module",
  "scripts": {
    "test": "node --import tsx --test test/*.test.ts"
  },
  "dependencies": {
    "@prisma/client": "7.10.0",
    "@prisma/adapter-better-sqlite3": "7.10.0"
  },
  "devDependencies": {
    "tsx": "4.23.15",
    "@types/node": "24.19.2",
    "prisma": "7.10.0"
  }
}

generator client {
  provider = "prisma-client"
  output   = "../src/generated/prisma"
}

datasource db {
  provider = "sqlite"
}

model User {
  id    Int    @id @default(autoincrement())
  email String @unique
  posts Post[]
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  author   User   @relation(fields: [authorId], references: [id])
  authorId Int
}

import { defineConfig } from "prisma/config";
export default defineConfig({
  schema: "prisma/schema.prisma",
  datasource: { url: "file:./test.db" },
});

import { PrismaBetterSqlite3 } from "@prisma/adapter-better-sqlite3";
import { PrismaClient } from "./generated/prisma/client.ts";

export function createClient(url = "file:./test.db") {
  return new PrismaClient({ adapter: new PrismaBetterSqlite3({ url }) });
}

import { test } from "node:test";
import assert from "node:assert/strict";
import { createClient } from "../src/db.ts";

test("create user with posts and query relation", async () => {
  const prisma = createClient();
  await prisma.post.deleteMany();
  await prisma.user.deleteMany();
  await prisma.user.create({ data: { email: "a@example.com", posts: { create: [{ title: "one" }, { title: "two" }] } } });
  const user = await prisma.user.findUnique({ where: { email: "a@example.com" }, include: { posts: true } });
  assert.equal(user?.posts.length, 2);
  await prisma.$disconnect();
});