sqlite3 OS agnostic #1828

Issue Summary

Greetings for our vscode extension we are using sqlite3. We build our extension on windows but since sqlite3 relies on native binaries it fails on macOS. We have raised a report with sqltools vscode extension as their tool sucessfully workS on windows macOS and other environments. It seems when we use sql tools it complies to work for the OS the program was built on therefore once deployed macOS users get an error

Relevant logs or output

mainThreadExtensionService.ts:107 Activating extension 'windmillcode-publisher-0.lib-tracker' failed:
dlopen(/[REDACTED]/.vscode/extensions/windmillcode-publisher-0.lib-tracker-1.100.1000/node_modules/sqlite3/build/Release/node_sqlite3.node, 0x0001): tried: '/[REDACTED]/.vscode/extensions/windmillcode-publisher-0.lib-tracker-1.100.1000/node_modules/sqlite3/build/Release/node_sqlite3.node' (slice is not valid mach-o file), '/System/Volumes/Preboot/Cryptexes/OS/[REDACTED]/.vscode/extensions/windmillcode-publisher-0.lib-tracker-1.100.1000/node_modules/sqlite3/build/Release/node_sqlite3.node' (no such file), '/[REDACTED]/.vscode/extensions/windmillcode-publisher-0.lib-tracker-1.100.1000/node_modules/sqlite3/build/Release/node_sqlite3.node' (slice is not valid mach-o file).

Version

v5.1.7

Node.js Version

v22.15.1

How did you install the library?

npm install sqlite3