sqlite-executor

A lightweight, zero-dependency SQLite wrapper for Node.js that communicates with the sqlite3 CLI via stdin/stdout — no native addons, no node-gyp, no ABI headaches. Version 4.0.6 requires Node.js >= 18 and the sqlite3 CLI executable on the system. Key differentiators: pure JavaScript, no compilation needed; long-lived single sqlite3 process for the entire app lifecycle; Promise-based API with execute(), query(), and stream() methods; automatic transaction support with concurrent caller serialization; dedicated reader pool for concurrent read queries; per-statement timeout with process-level failure recovery; auto-restart on crash; runtime metrics (QPS, avg query time, timeout count, restarts). Includes full TypeScript types and dual ESM/CommonJS module support.