node-sqlite-vec

Recipe for combining Node 24's built-in node:sqlite with the sqlite-vec extension. Each section below is a known pitfall paired with the working incantation — read the Pitfalls section first if you only have a minute.

When to use

• Adding vector search / RAG storage to a Node 24+ project
• You want to avoid the native build dance of better-sqlite3
• TypeScript source that runs directly with --experimental-strip-types

Skip this skill if:

• Your runtime is Node ≤ 22 (no built-in node:sqlite) — use better-sqlite3
• You need server-grade concurrency / replication — SQLite is the wrong tool

Pitfalls (read first)