Dashboardopencode-lorenode-sqlite3-wasm compatibility fallback

node-sqlite3-wasm compatibility fallback

Category: architecture
Confidence: 1.00
ID: 01a0a58e-b018-7531-8117-db9efbf52208
Project ID: 6f4be9ff-ed84-4cca-a9e7-732a0b0b8677
Cross-project: No
Recalled in other projects: 0
Source session: 1JmtIdaVnn5PTPdxS
Created: 2026-09-15 14:53:06
Updated: 2026-09-15 14:53:06

Content

Chose lazy node-sqlite3-wasm for Node 18–22.14 over better-sqlite3 because externalizing the fallback preserves the standalone SEA binary’s no-runtime-dependencies and zero-byte-overhead constraints; SEA embeds modern Node and always uses node:sqlite. The fallback cannot use WAL and is slower under concurrency, which is acceptable only for the single-process CLI; modern Node or the standalone binary remains preferred.

Move to: