better-sqlite3

better-sqlite3 binds the SQLite C library into Node. Queries run synchronously, which sounds wrong for Node but suits SQLite, because each call finishes in microseconds and there is no network to wait on. It supports transactions, prepared statements and loading extensions such as sqlite-vec.

As a native module it has to match the Node version and platform it runs on, and it cannot run on edge runtimes. Newer Node versions also include a built-in node:sqlite module.