prisma-adapter-node-sqlite

This is a Prisma adapter for the native node:sqlite database. It is heavily inspired by the @prisma/adapter-better-sqlite3 adapter.

Installation

$ npm i prisma-adapter-node-sqlite

Connection details

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

Instantiation

import { PrismaNodeSQLite } from 'prisma-adapter-node-sqlite';

const adapter = new PrismaNodeSQLite({
  url: 'file:./prisma/dev.db',
});
const prisma = new PrismaClient({ adapter });

Configure timestamp format for backward compatibility

import { PrismaNodeSQLite } from 'prisma-adapter-node-sqlite';

const adapter = new PrismaNodeSQLite(
  {
    url: 'file:./prisma/dev.db',
  },
  { timestampFormat: 'unixepoch-ms' }
);
const prisma = new PrismaClient({ adapter });

When to use each format:

• ISO 8601 (default): Best for new projects and integrates well with SQLite's built-in date/time functions.
• unixepoch-ms: Required when migrating from Prisma ORM's native SQLite driver to maintain compatibility with existing timestamp data.

Native type mapping from Prisma ORM to node:sqlite

| Prisma ORM | node:sqlite | | ---------- | ------------- | | String | TEXT | | Boolean | BOOLEAN | | Int | INTEGER | | BigInt | INTEGER | | Float | REAL | | Decimal | DECIMAL | | DateTime | NUMERIC | | Json | JSONB | | Bytes | BLOB | | Enum | TEXT |