Error installing sqlite3 on Windows ARM64

[vicancy]

Issue Summary

Failed to install the package on Windows ARM64. Tried all the installation options but none works.

• No prebuilt binaries available for win-arm64
• npm install sqlite3 fails
• npm install sqlite3 --build-from-source fails
• Prebuild sqlite3.exe from source code and run npm install sqlite3 --build-from-source --sqlite /out also fails...

Any help or hints are appreciated.

Relevant logs or output

• With node-gyp -v v8.4.1 it fails to find arm64 version windows SDK:

  550 error gyp ERR! find VS checking VS2022 (17.12.35506.116) found at:
  550 error gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools"
  550 error gyp ERR! find VS - found "Visual Studio C++ core features"
  550 error gyp ERR! find VS - found VC++ toolset: v143
  550 error gyp ERR! find VS - missing any Windows SDK

  full log: 2024-11-13T08_06_28_038Z-debug-0.log

• With node-gyp -v v10.2.0 it fails to find build tools for v143 :

  error C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\MSBuild\Microsoft\VC\v170\Microsoft.CppBuild.targets(456,5): error MSB8020: The build tools for v143 (Platform Toolset = 'v143') cannot be found. To build using the v143 build tools, please install v143 build tools.  Alternatively, you may upgrade to the current Visual Studio tools by selecting the Project menu or right-click the solution, and then selecting "Retarget solution". [C:\dummy\node_modules\sqlite3\node-addon-api\nothing.vcxproj]

  full log: 2024-11-13T08_07_34_886Z-debug-0.log

Version

latest

Node.js Version

22.11.0

How did you install the library?

windows-arm64

[vicancy]

I succeeded after I uninstalled all the visual studio versions and reinstalled from visual studio installer... not use choco install. The components MSVC v143 - VS 2022 C++ ARM64/ARM64EC and Windows 10 SDK (10.0.20348.0) are the must have (looks like node-gyp expects this exact windows SDK version 10.0.20348.0)