[BUG] prebuilt file better-sqlite3 cannot work on Opencode v1.18.3

[Kingor-blip]

Describe the bug
the prebuilt file better-sqlite3 cannot work on Opencode v1.18.3, the opencode-mem0.log show that :

[2026-07-19T16:23:40.466Z] [INFO] handleListMemories: error: {"error":"Error: The module '\\?\C:\Users\aa\.cache\opencode\packages\opencode-mem0@latest\node_modules\better-sqlite3\build\Release\better_sqlite3.node'\nwas compiled against a different Node.js version using\nNODE_MODULE_VERSION 137. This version of Node.js requires\nNODE_MODULE_VERSION 146. Please try re-compiling or re-installing\nthe module (for instance, using npm rebuild or npm install)."}

[ZeR020]

Fixed in v2.18.4 (commit f0249d0, now on main; npm publish will follow via the release workflow).

Root cause: better-sqlite3@12 ships prebuilt .node binaries compiled against Node ABI 137 (Node 22). OpenCode v1.18.3 bundles Node 24 (ABI 146), so the native binary failed to load — NODE_MODULE_VERSION 137 ... requires 146 — and every memory operation threw.

Fix: The SQLite bootstrap now probes backends in ABI-safety order:

bun:sqlite  →  node:sqlite (Node stdlib, no native binary)  →  better-sqlite3 (last resort)

On Node 24, node:sqlite is selected — it's part of Node itself, so there's no .node file and no ABI mismatch is possible. Each candidate is load-tested with a :memory: open/close before selection, so a broken native build is never picked silently.

Thanks for the clear report @Kingor-blip — the log snippet pinpointed it instantly. Upgrade with opencode plugin update opencode-mem0 (or reinstall opencode-mem0@latest) once v2.18.4 lands on npm.