Drizzle ORM recipes
6 tested Drizzle ORM integration recipes with @auth/drizzle-adapter, @auth/core, @electric-sql/pglite, better-sqlite3. Exact pinned versions and a last-passed receipt, last run 2026-10-15.
Auth.js Drizzle adapter on PGlite Postgres (database sessions)
Set up @auth/drizzle-adapter with the standard Postgres tables on Drizzle, and test user, account linking and database session lifecycle against in-memory PGlite.
Drizzle ORM + better-sqlite3 CRUD
Typed schema, migrations-free table creation and CRUD with Drizzle on an in-memory SQLite database.
Drizzle ORM + drizzle-zod validated inserts on SQLite
Generate Zod insert and select schemas from Drizzle tables with drizzle-zod, refine them, and validate input before inserting into SQLite.
Drizzle ORM + PGlite in-memory Postgres
Real Postgres semantics in tests with no server: Drizzle ORM on PGlite (WASM Postgres) with relations, returning() and transactions.
Drizzle ORM migrations on PGlite (in-memory Postgres)
Apply versioned SQL migrations with Drizzle's PGlite migrator, use Postgres features (jsonb, enums, arrays, onConflictDoUpdate) and test against a fresh in-memory database.
Hono + Drizzle ORM + SQLite REST API (Vitest)
CRUD REST API in Hono backed by Drizzle ORM on better-sqlite3, with Zod validation, tested with Vitest and app.request().
Used together with Drizzle ORM
@auth/drizzle-adapter@auth/core@electric-sql/pglitebetter-sqlite3SQLitedrizzle-zodZodpostgresHono@hono/zod-validatorvitest