sqlite3 OS agnostic

[i-can-code-this]

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

[kewde]

There are prebuilts .node files published for each platform (linux, macos, windows etc).
Based on the file paths build/Release/node_sqlite3.node you seem to be shipping only the Windows build, you'll need to either revert back to using & shipping all the prebuilts. Or provide your own prebuilts for each platform & architecture.

[i-can-code-this]

I am aware of that how do I go about doing that is the question