better-sqlite3

The fastest and simplest SQLite library for Node.js, with a synchronous API that outperforms alternatives like sqlite3 by 2-24x in common operations. Version 12.10.0 requires Node.js 20+ and includes prebuilt binaries for LTS. Key differentiators: full transaction support, user-defined functions/aggregates/virtual tables, 64-bit integer support, and worker thread compatibility. The synchronous API is designed to be safer and more efficient than async equivalents for SQLite's inherently single-threaded nature.