drizzle-sqlite

library0.0.1jsnpmunverified

Drizzle ORM adapter for Node.js built-in SQLite driver. Current stable version 0.0.1, daily releases under active development. Provides a type-safe SQLite query builder and ORM leveraging the native sqlite module available in Node.js v24+. Key differentiator: zero extra dependencies beyond drizzle-orm, uses Node's built-in driver instead of sql.js or better-sqlite3. Primarily for server-side Node.js applications targeting modern Node versions.

database

npm install drizzle-sqlite

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · DRIZZLE-SQLITE

drizzle-sqlite

databasejavascriptv0.0.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

drizzle

✓ import { drizzle } from 'drizzle-sqlite'

✗ const { drizzle } = require('drizzle-sqlite')

ESM-only package. CommonJS require will fail.

Database

✓ import type { Database } from 'drizzle-sqlite'

✗ import { Database } from 'drizzle-sqlite'

Database is a type export, not runtime value. Use type import.

DrizzleConfig

✓ import type { DrizzleConfig } from 'drizzle-sqlite'

✗ import { DrizzleConfig } from 'drizzle-sqlite'

DrizzleConfig is a type export for configuration options.

Initializes an in-memory SQLite database using Node.js built-in driver, creates a table, inserts data, and queries via Drizzle ORM.

import { drizzle } from 'drizzle-sqlite'; import { DatabaseSync } from 'node:sqlite'; const sqlite = new DatabaseSync(':memory:'); sqlite.exec(`CREATE TABLE users ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT UNIQUE )`); const db = drizzle(sqlite); // Insert a user const insertStmt = sqlite.prepare('INSERT INTO users (name, email) VALUES (?, ?)'); insertStmt.run('Alice', 'alice@example.com'); insertStmt.run('Bob', 'bob@example.com'); // Query using Drizzle ORM import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; const users = sqliteTable('users', { id: integer('id').primaryKey(), name: text('name'), email: text('email'), }); const result = db.select({ name: users.name, email: users.email }).from(users).all(); console.log(result);

Debug

Known issues

breakingRequires Node.js v24+ (built-in sqlite module)

fix

Upgrade Node.js to v24+ or use a different driver (better-sqlite3, sql.js)

affects: <0.0.1

gotchaESM-only package; CommonJS require will throw ERR_REQUIRE_ESM

fix

Use dynamic import() for CJS projects or switch to ESM

affects: >=0.0.1

gotchaDatabase and DrizzleConfig are type-only exports, not runtime constructs

fix

Use import type syntax: import type { Database } from 'drizzle-sqlite'

affects: >=0.0.1

deprecatedDepends on drizzle-orm ^0.45.2; incompatible with major version >0.45.x

fix

Ensure package.json includes drizzle-orm@0.45.x

affects: >=0.0.1

gotchaNode.js built-in sqlite DatabaseSync and DatabaseAsync APIs are experimental and may change

fix

Use with caution and pin Node.js version in production

affects: >=0.0.1

Errors

Common errors & fixes

TypeError: The 'original' argument must be of type function. Received undefined

Incorrect import – using require() instead of import for ESM-only package

fix

Change to import { drizzle } from 'drizzle-sqlite' and ensure project is ESM

Error: No such module 'drizzle-orm'

Missing peer dependency drizzle-orm

fix

Install drizzle-orm: npm install drizzle-orm@0.45.x

TypeError: drizzle is not a function

CommonJS require of a named export that is actually default export

fix

Use import { drizzle } from 'drizzle-sqlite' (ESM) or import drizzle from 'drizzle-sqlite' (if default export exists – check docs)

Upgrade

Version history

0.0.1latest on npm

Audit

Dependencies

drizzle-ormrequiredCore Drizzle ORM library – required peer dependency for query building and migration

Agent activity

7 hits · last 30 days

node

Resources

githubhttps://github.com/yjl9903/drizzle-sqlite ↗

packagedrizzle-sqlite ↗

homepagehttps://github.com/yjl9903/drizzle-sqlite#readme ↗