GitHub - photostructure/node-sqlite: Drop-in replacement for `node:sqlite`

Native SQLite for Node.js 20+. Drop-in replacement for node:sqlite. Synced with Node.js v25.8.1 for the latest features including native Symbol.dispose resource management.

Installation

npm install @photostructure/sqlite

Quick Start

import { DatabaseSync } from "@photostructure/sqlite";

const db = new DatabaseSync(":memory:");
db.exec("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)");
const insert = db.prepare("INSERT INTO users (name) VALUES (?)");
insert.run("Alice");
const users = db.prepare("SELECT * FROM users").all();
console.log(users); // [{ id: 1, name: 'Alice' }]
db.close();

Features

100% compatible with Node.js v25.8.1 built-in node:sqlite module*
Zero dependencies - native SQLite implementation
Synchronous API - no async overhead
Performance comparable to better-sqlite3
Full SQLite feature set (details)
TypeScript support with complete type definitions
Cross-platform prebuilt binaries (Windows/macOS/Linux, x64/ARM64)
User-defined functions and aggregates
Database backups and session/changeset support
Session class exposed for advanced replication workflows
Native Symbol.dispose for resource management
enhance() function for better-sqlite3 style .pragma() and .transaction() methods
URI filename support for advanced configuration
Worker thread safe
Compare with other libraries →

Note

*API-compatible with Node.js SQLite, but this library adopts SQLite-recommended features and security-enhancing build flags. See build configuration details.

Documentation

Getting Started

Using SQLite

Reference

License

MIT - see LICENSE for details.

This package includes SQLite (public domain) and code from Node.js (MIT licensed).

Note: This package is not affiliated with the Node.js project. It extracts and redistributes Node.js's SQLite implementation under the MIT license.