Bug: sqlite-vec extension fails to load on Windows
Environment:
- Platform: Windows
- OpenClaw Version: 2026.4.11
- Node.js: v24.14.1
- better-sqlite3: 12.8.0
- sqlite-vec: 0.1.7 / 0.1.9 (both tested)
Issue:
Active Memory falls back to FTS-only mode. The sqlite-vec DLL loads without throwing an error, but loadExtension() silently fails to register any functions (�ec0_version() returns 'no such function').
Reproduction:
javascript const Database = require('better-sqlite3'); const sqliteVec = require('sqlite-vec'); const db = new Database(':memory:'); db.loadExtension(sqliteVec.getLoadablePath()); // succeeds silently db.exec('SELECT vec0_version()'); // throws: no such function
Root Cause:
The sqlite-vec Windows DLL appears to be compiled against an older SQLite version (pre-3.45), incompatible with better-sqlite3 12.8.0's bundled SQLite.
Expected:
Vector search should work.
Actual:
memory_search always returns ts-only mode, provider: 'none'.
Bug: sqlite-vec extension fails to load on Windows
Environment:
Issue:
Active Memory falls back to FTS-only mode. The sqlite-vec DLL loads without throwing an error, but loadExtension() silently fails to register any functions (�ec0_version() returns 'no such function').
Reproduction:
javascript const Database = require('better-sqlite3'); const sqliteVec = require('sqlite-vec'); const db = new Database(':memory:'); db.loadExtension(sqliteVec.getLoadablePath()); // succeeds silently db.exec('SELECT vec0_version()'); // throws: no such functionRoot Cause:
The sqlite-vec Windows DLL appears to be compiled against an older SQLite version (pre-3.45), incompatible with better-sqlite3 12.8.0's bundled SQLite.
Expected:
Vector search should work.
Actual:
memory_search always returns ts-only mode, provider: 'none'.