# Not able to install SQLite

**URL:** <https://discourse.nodered.org/t/not-able-to-install-sqlite/49745>\
**Category:** General\
**Created:** [15 August 2021 12:09 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745 "2021-08-15T12:09:55Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![KratosReus](https://avatars.discourse-cdn.com/v4/letter/k/f19dbf/32.png) [@KratosReus](https://discourse.nodered.org/u/KratosReus)\
**Post date:** [15 August 2021 12:09 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/1 "2021-08-15T12:09:55Z")

</div>

Hi everyone,

I have been trying to install the SQLite node but it always triggers some errors:

> Blockquote----------------------------------------------------------  
> 2021-08-15T12:02:32.722Z Install : node-red-node-sqlite 0.6.0  
> 2021-08-15T12:02:33.034Z npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@0.6.0  
> 2021-08-15T12:02:34.382Z [err] npm  
> 2021-08-15T12:02:34.382Z [err] WARN deprecated node-pre-gyp@0.11.0: Please upgrade to @mapbox/node-pre-gyp: the non-scoped node-pre-gyp package is deprecated and only the @mapbox scoped package will recieve updates in the future  
> 2021-08-15T12:02:35.908Z [out]  
> 2021-08-15T12:02:35.908Z [out] \> sqlite3@4.2.0 install C:\Users\Kratos.node-red\node\_modules\sqlite3  
> 2021-08-15T12:02:35.908Z [out] \> node-pre-gyp install --fallback-to-build  
> 2021-08-15T12:02:35.908Z [out]  
> 2021-08-15T12:02:36.146Z [err] node-pre-gyp  
> 2021-08-15T12:02:36.146Z [err] WARN  
> 2021-08-15T12:02:36.147Z [err] Using request for node-pre-gyp https download  
> 2021-08-15T12:02:36.654Z [err] node-pre-gyp  
> 2021-08-15T12:02:36.654Z [err] WARN Tried to download(403): [https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz)  
> 2021-08-15T12:02:36.654Z [err] node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.17.3 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)  
> 2021-08-15T12:02:38.016Z [out] Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.  
> 2021-08-15T12:02:38.818Z [out] unpack\_sqlite\_dep  
> 2021-08-15T12:02:38.819Z [out] 'python' is not recognized as an internal or external command,  
> 2021-08-15T12:02:38.819Z [out] operable program or batch file.  
> 2021-08-15T12:02:38.846Z [out] C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\Common7\IDE\VC\VCTargets\Microsoft.CppCommon.targets(209,5): error MSB6006: "cmd.exe" exited with code 1. [C:\Users\Kratos.node-red\node\_modules\sqlite3\build\deps\action\_before\_build.vcxproj]  
> 2021-08-15T12:02:38.886Z [err] gyp  
> 2021-08-15T12:02:38.886Z [err] ERR! build error  
> 2021-08-15T12:02:38.886Z [err] gyp  
> 2021-08-15T12:02:38.886Z [err] ERR! stack  
> 2021-08-15T12:02:38.886Z [err] Error: `C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\MSBuild.exe` failed with exit code: 1  
> 2021-08-15T12:02:38.886Z [err] gyp ERR! stack at ChildProcess.onExit (C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\build.js:194:23)  
> 2021-08-15T12:02:38.886Z [err] gyp  
> 2021-08-15T12:02:38.886Z [err] ERR! stack at ChildProcess.emit (events.js:375:28)  
> 2021-08-15T12:02:38.886Z [err] gyp ERR!  
> 2021-08-15T12:02:38.886Z [err] stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:277:12)  
> 2021-08-15T12:02:38.886Z [err] gyp  
> 2021-08-15T12:02:38.886Z [err] ERR! System Windows\_NT 10.0.19042  
> 2021-08-15T12:02:38.886Z [err] gyp ERR! command  
> 2021-08-15T12:02:38.886Z [err] "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js" "build" "--fallback-to-build" "--module=C:\Users\Kratos\.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node" "--module\_name=node\_sqlite3" "--module\_path=C:\Users\Kratos\.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64" "--napi\_version=8" "--node\_abi\_napi=napi" "--napi\_build\_version=0" "--node\_napi\_label=node-v83"  
> 2021-08-15T12:02:38.886Z [err] gyp ERR!  
> 2021-08-15T12:02:38.886Z [err] cwd C:\Users\Kratos.node-red\node\_modules\sqlite3  
> 2021-08-15T12:02:38.886Z [err] gyp ERR! node -v  
> 2021-08-15T12:02:38.886Z [err] v14.17.3  
> 2021-08-15T12:02:38.886Z [err] gyp ERR! node-gyp -v  
> 2021-08-15T12:02:38.886Z [err] v5.1.0  
> 2021-08-15T12:02:38.886Z [err] gyp ERR! not ok  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp  
> 2021-08-15T12:02:38.891Z [err] ERR! build error  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp  
> 2021-08-15T12:02:38.891Z [err] ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node --module\_name=node\_sqlite3 --module\_path=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi\_version=8 --node\_abi\_napi=napi --napi\_build\_version=0 --node\_napi\_label=node-v83' (1)  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR!  
> 2021-08-15T12:02:38.891Z [err] stack at ChildProcess. (C:\Users\Kratos.node-red\node\_modules\node-pre-gyp\lib\util\compile.js:83:29)  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! stack  
> 2021-08-15T12:02:38.891Z [err] at ChildProcess.emit (events.js:375:28)  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! stack at maybeClose (internal/child\_process.js:1055:16)  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp  
> 2021-08-15T12:02:38.891Z [err] ERR! stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:288:5)  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp  
> 2021-08-15T12:02:38.891Z [err] ERR! System Windows\_NT 10.0.19042  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\Kratos\.node-red\node\_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! cwd C:\Users\Kratos.node-red\node\_modules\sqlite3  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! node -v v14.17.3  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! node-pre-gyp -v v0.11.0  
> 2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! not ok  
> 2021-08-15T12:02:38.892Z [out] Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node --module\_name=node\_sqlite3 --module\_path=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi\_version=8 --node\_abi\_napi=napi --napi\_build\_version=0 --node\_napi\_label=node-v83' (1)  
> 2021-08-15T12:02:39.022Z [err] npm ERR! code  
> 2021-08-15T12:02:39.022Z [err] ELIFECYCLE  
> 2021-08-15T12:02:39.022Z [err] npm ERR! errno 1  
> 2021-08-15T12:02:39.025Z [err] npm ERR!  
> 2021-08-15T12:02:39.025Z [err] sqlite3@4.2.0 install: `node-pre-gyp install --fallback-to-build`  
> 2021-08-15T12:02:39.025Z [err] npm ERR! Exit status 1  
> 2021-08-15T12:02:39.025Z [err] npm ERR!  
> 2021-08-15T12:02:39.025Z [err] npm  
> 2021-08-15T12:02:39.025Z [err] ERR! Failed at the sqlite3@4.2.0 install script.  
> 2021-08-15T12:02:39.025Z [err] npm ERR! This is probably not a problem with npm. There is likely additional logging output above.  
> 2021-08-15T12:02:39.031Z [err]  
> 2021-08-15T12:02:39.031Z [err] npm ERR! A complete log of this run can be found in:  
> 2021-08-15T12:02:39.031Z [err] npm ERR! C:\Users\Kratos\AppData\Roaming\npm-cache\_logs\2021-08-15T12\_02\_39\_028Z-debug.log  
> 2021-08-15T12:02:39.045Z rc=1

Does it mean I need to have a prior version of Node.js installed? What should I do to overcome this issue? I've tried some things I have searched here for but didn't get any luck.

Thanks

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [15 August 2021 12:28 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/2 "2021-08-15T12:28:29Z")

</div>

It's a little buried in the log, but the relevant error is this one:

> [@KratosReus](#):
>
> ] unpack\_sqlite\_dep  
> 2021-08-15T12:02:38.819Z [out] 'python' is not recognized as an internal or external command,  
> 2021-08-15T12:02:38.819Z [out] operable program or batch file.

You will need to have python installed and available on your path.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 August 2021 12:29 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/3 "2021-08-15T12:29:23Z")

</div>

> [@KratosReus](#):
>
> 2021-08-15T12:02:38.819Z [out] 'python' is not recognized as an internal or external command

Python is not found. Did you install windows-build-tools?

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [15 August 2021 12:30 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/4 "2021-08-15T12:30:52Z")

</div>

> [@KratosReus](#):
>
> Does it mean I need to have a prior version of Node.js installed? What should I do to overcome this issue?

No need to downgrade your nodejs. But because sqlite3 depends on some binary files that need to be built, your system needs the necessary tools to do that (windows-build-tools). The command to install it :

```auto
npm install --global windows-build-tools

```

> [@Unable to install SQlite](https://discourse.nodered.org/t/unable-to-install-sqlite/41878/2):
>
> you need windows-build-tools npm install --global windows-build-tools it can take a long time & appear stuck - wait it out, then try install sqlite once more ALSO... looks like you were in wrong folder. make sure command prompt is inside your node-red folder (normally c:\users\username\.node-red)

@dceejay could these problems with installation of the popular sqlite node be avoided if we bump up the dependancy version of sqlite3 to 5.0.2. It says in the chance log that they rebuilt the binaries ?  
[Changelog](https://github.com/mapbox/node-sqlite3/blob/master/CHANGELOG.md)

---

<div class="post-metadata">

**Author:** ![KratosReus](https://avatars.discourse-cdn.com/v4/letter/k/f19dbf/32.png) [@KratosReus](https://discourse.nodered.org/u/KratosReus)\
**Post date:** [15 August 2021 15:17 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/5 "2021-08-15T15:17:40Z")

</div>

Hello.

I've uninstalled and installed python already and that error does not appear now but I have a new one related with the visual studio:

> Blockquote  
> 2021-08-15T15:08:54.413Z Install : node-red-node-sqlite 0.6.0  
> 2021-08-15T15:08:54.731Z npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@0.6.0  
> 2021-08-15T15:08:56.388Z [err] npm  
> 2021-08-15T15:08:56.388Z [err] WARN deprecated node-pre-gyp@0.11.0: Please upgrade to @mapbox/node-pre-gyp: the non-scoped node-pre-gyp package is deprecated and only the @mapbox scoped package will recieve updates in the future  
> 2021-08-15T15:08:58.079Z [out]  
> 2021-08-15T15:08:58.079Z [out] \> sqlite3@4.2.0 install C:\Users\Kratos.node-red\node\_modules\sqlite3  
> 2021-08-15T15:08:58.079Z [out] \> node-pre-gyp install --fallback-to-build  
> 2021-08-15T15:08:58.079Z [out]  
> 2021-08-15T15:08:58.330Z [err] node-pre-gyp  
> 2021-08-15T15:08:58.330Z [err]  
> 2021-08-15T15:08:58.330Z [err] WARN Using request for node-pre-gyp https download  
> 2021-08-15T15:08:58.843Z [err] node-pre-gyp  
> 2021-08-15T15:08:58.843Z [err] WARN Tried to download(403): [https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz)  
> 2021-08-15T15:08:58.843Z [err] node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.17.3 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)  
> 2021-08-15T15:08:59.960Z [err] gyp  
> 2021-08-15T15:08:59.960Z [err] ERR! find VS  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS msvs\_version was set from command line or npm config  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS  
> 2021-08-15T15:08:59.960Z [err] - looking for Visual Studio version 2015  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS checking VS2019 (16.11.31605.320) found at:  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found "Visual Studio C++ core features"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found VC++ toolset: v142  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found Windows SDK: 10.0.19041.0  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - msvs\_version does not match this version  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS  
> 2021-08-15T15:08:59.960Z [err] checking VS2017 (15.9.28307.1622) found at:  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found "Visual Studio C++ core features"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS - found VC++ toolset: v141  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found Windows SDK: 10.0.17763.0  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - msvs\_version does not match this version  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS could not find a version of Visual Studio 2017 or newer to use  
> 2021-08-15T15:08:59.960Z [err] gyp  
> 2021-08-15T15:08:59.960Z [err] ERR! find VS looking for Visual Studio 2015  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS - not found  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8  
> 2021-08-15T15:08:59.960Z [err] gyp  
> 2021-08-15T15:08:59.960Z [err] ERR! find VS  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS  
> 2021-08-15T15:08:59.960Z [err] valid versions for msvs\_version:  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - "2019"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - "2017"  
> 2021-08-15T15:08:59.960Z [err] gyp  
> 2021-08-15T15:08:59.960Z [err] ERR! find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
> 2021-08-15T15:08:59.960Z [err] gyp  
> 2021-08-15T15:08:59.961Z [err] ERR! find VS You need to install the latest version of Visual Studio  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! find VS  
> 2021-08-15T15:08:59.961Z [err] including the "Desktop development with C++" workload.  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! find VS For more information consult the documentation at:  
> 2021-08-15T15:08:59.961Z [err] gyp ERR!  
> 2021-08-15T15:08:59.961Z [err] find VS [GitHub - nodejs/node-gyp: Node.js native addon build tool](https://github.com/nodejs/node-gyp#on-windows)  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! find VS \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! find VS  
> 2021-08-15T15:08:59.961Z [err] gyp  
> 2021-08-15T15:08:59.961Z [err] ERR! configure error  
> 2021-08-15T15:08:59.961Z [err] gyp ERR!  
> 2021-08-15T15:08:59.961Z [err] stack Error: Could not find any Visual Studio installation to use  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack at VisualStudioFinder.fail (C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\find-visualstudio.js:121:47)  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack at C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\find-visualstudio.js:74:16  
> 2021-08-15T15:08:59.961Z [err] gyp  
> 2021-08-15T15:08:59.961Z [err] ERR! stack at VisualStudioFinder.findVisualStudio2013 (C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\find-visualstudio.js:351:14)  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack  
> 2021-08-15T15:08:59.961Z [err] at C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\find-visualstudio.js:70:14  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack at C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\find-visualstudio.js:372:16  
> 2021-08-15T15:08:59.961Z [err] gyp  
> 2021-08-15T15:08:59.961Z [err] ERR! stack at C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\util.js:54:7  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack  
> 2021-08-15T15:08:59.961Z [err] at C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\lib\util.js:33:16  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack at ChildProcess.exithandler (child\_process.js:326:5)  
> 2021-08-15T15:08:59.961Z [err] gyp  
> 2021-08-15T15:08:59.961Z [err] ERR! stack at ChildProcess.emit (events.js:375:28)  
> 2021-08-15T15:08:59.961Z [err] gyp ERR! stack  
> 2021-08-15T15:08:59.961Z [err] at maybeClose (internal/child\_process.js:1055:16)  
> 2021-08-15T15:08:59.962Z [err] gyp  
> 2021-08-15T15:08:59.962Z [err] ERR! System Windows\_NT 10.0.19042  
> 2021-08-15T15:08:59.962Z [err] gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\Users\Kratos\.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node" "--module\_name=node\_sqlite3" "--module\_path=C:\Users\Kratos\.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64" "--napi\_version=8" "--node\_abi\_napi=napi" "--napi\_build\_version=0" "--node\_napi\_label=node-v83" "--python=python2.7" "--msvs\_version=2015"  
> 2021-08-15T15:08:59.962Z [err] gyp  
> 2021-08-15T15:08:59.962Z [err] ERR! cwd C:\Users\Kratos.node-red\node\_modules\sqlite3  
> 2021-08-15T15:08:59.962Z [err] gyp  
> 2021-08-15T15:08:59.962Z [err] ERR! node -v v14.17.3  
> 2021-08-15T15:08:59.962Z [err] gyp ERR!  
> 2021-08-15T15:08:59.962Z [err] node-gyp -v v5.1.0  
> 2021-08-15T15:08:59.962Z [err] gyp ERR!  
> 2021-08-15T15:08:59.962Z [err] not ok  
> 2021-08-15T15:08:59.967Z [err] node-pre-gyp  
> 2021-08-15T15:08:59.967Z [err] ERR! build error  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp  
> 2021-08-15T15:08:59.968Z [err] ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node --module\_name=node\_sqlite3 --module\_path=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi\_version=8 --node\_abi\_napi=napi --napi\_build\_version=0 --node\_napi\_label=node-v83 --python=python2.7 --msvs\_version=2015' (1)  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR!  
> 2021-08-15T15:08:59.968Z [err] stack at ChildProcess. (C:\Users\Kratos.node-red\node\_modules\node-pre-gyp\lib\util\compile.js:83:29)  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! stack at ChildProcess.emit (events.js:375:28)  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! stack at maybeClose (internal/child\_process.js:1055:16)  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp  
> 2021-08-15T15:08:59.968Z [err] ERR! stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:288:5)  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp  
> 2021-08-15T15:08:59.968Z [err] ERR! System Windows\_NT 10.0.19042  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\Kratos\.node-red\node\_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! cwd C:\Users\Kratos.node-red\node\_modules\sqlite3  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp  
> 2021-08-15T15:08:59.968Z [err] ERR! node -v v14.17.3  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp  
> 2021-08-15T15:08:59.968Z [err] ERR! node-pre-gyp -v v0.11.0  
> 2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR!  
> 2021-08-15T15:08:59.968Z [err] not ok  
> 2021-08-15T15:08:59.968Z [out] Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node --module\_name=node\_sqlite3 --module\_path=C:\Users\Kratos.node-red\node\_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi\_version=8 --node\_abi\_napi=napi --napi\_build\_version=0 --node\_napi\_label=node-v83 --python=python2.7 --msvs\_version=2015' (1)  
> 2021-08-15T15:09:00.095Z [err] npm ERR!  
> 2021-08-15T15:09:00.095Z [err] code ELIFECYCLE  
> 2021-08-15T15:09:00.095Z [err] npm ERR! errno 1  
> 2021-08-15T15:09:00.098Z [err] npm ERR!  
> 2021-08-15T15:09:00.098Z [err] sqlite3@4.2.0 install: `node-pre-gyp install --fallback-to-build`  
> 2021-08-15T15:09:00.098Z [err] npm ERR! Exit status 1  
> 2021-08-15T15:09:00.098Z [err] npm ERR!  
> 2021-08-15T15:09:00.098Z [err] npm ERR! Failed at the sqlite3@4.2.0 install script.  
> 2021-08-15T15:09:00.098Z [err] npm ERR! This is probably not a problem with npm. There is likely additional logging output above.  
> 2021-08-15T15:09:00.104Z [err]  
> 2021-08-15T15:09:00.104Z [err] npm ERR! A complete log of this run can be found in:  
> 2021-08-15T15:09:00.104Z [err] npm ERR! C:\Users\Kratos\AppData\Roaming\npm-cache\_logs\2021-08-15T15\_09\_00\_101Z-debug.log  
> 2021-08-15T15:09:00.117Z rc=1

I've previously installed Visual Studio and tried to install windows-build-tools but since it got stuck at having python installed again, I have gone with "npm install --global --production windows-build-tools --vs2015" instead and it finished with success.

However, I still have those errors.

Thanks in advance to everyone.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 August 2021 15:28 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/6 "2021-08-15T15:28:06Z")

</div>

> [@KratosReus](#):
>
> However, I still have those errors

I think you need v2017 or later.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [15 August 2021 15:56 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/7 "2021-08-15T15:56:08Z")

</div>

Won't installing the windows build tools as described in the docs fix that?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 August 2021 16:02 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/8 "2021-08-15T16:02:42Z")

</div>

The op said he installed build tools...

> [@KratosReus](#):
>
> I have gone with "npm install --global --production windows-build-tools --vs2015"

... but looking at the log, I suspect he needs a later version based on...

> [@KratosReus](#):
>
> 2021-08-15T15:08:59.960Z [err] ERR! find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"  
> 2021-08-15T15:08:59.960Z [err] gyp ERR!  
> 2021-08-15T15:08:59.960Z [err] find VS  
> 2021-08-15T15:08:59.960Z [err] gyp ERR! find VS \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
> 2021-08-15T15:08:59.960Z [err] gyp  
> 2021-08-15T15:08:59.961Z [err] ERR! find VS You need to install the latest version of Visual Studio

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [15 August 2021 16:17 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/9 "2021-08-15T16:17:11Z")

</div>

> [@Steve-Mcl](#):
>
> The op said he installed build tools

Sorry, I missed that, I am on my phone.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [15 August 2021 17:04 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/10 "2021-08-15T17:04:52Z")

</div>

Hi @UnborN  
happy to bump it up as long as someone tests it first. I'm almost finished vacation but cant test right now.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [15 August 2021 18:46 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/11 "2021-08-15T18:46:01Z")

</div>

> [@dceejay](#):
>
> happy to bump it up as long as someone tests it first

it looks ok on Win10. maybe my test was a bit unorthodox but i'll try to detail the steps i followed bellow.

1. made sure i didnt have installed `windows-build-tools` by running  
`npm uninstall --global windows-build-tools`
2. uninstalled the sqlite node from .node-red folder :  
`npm uninstall node-red-node-sqlite`
3. made sure `npm install node-red-node-sqlite` fails because of missing build tools
4. since i didnt have the package in node modules anymore to edit,  
i downloaded the .tzg file by following the link from the npm registry  
[https://registry.npmjs.org/node-red-node-sqlite/-/node-red-node-sqlite-0.6.0.tgz](https://registry.npmjs.org/node-red-node-sqlite/-/node-red-node-sqlite-0.6.0.tgz)
5. extracted it on my Desktop and modified its package.json to 5.0.2

```auto
"dependencies": {
        "sqlite3": "~5.0.2"
    },

```

1. from .node-red folder run :  
`npm install C:\Users\User\Desktop\node-red-node-sqlite-0.6.0\package`

2. installation of the node went through .. no binary builds since i presume the already compiled binaries for that version and OS were downloaded from _mapbox-node-binary_ ?

3. restarted node-red and the db connection seems fine with some simple reads.

---

<div class="post-metadata">

**Author:** ![KratosReus](https://avatars.discourse-cdn.com/v4/letter/k/f19dbf/32.png) [@KratosReus](https://discourse.nodered.org/u/KratosReus)\
**Post date:** [15 August 2021 21:07 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/12 "2021-08-15T21:07:42Z")

</div>

Hi,

Followed these steps and now I was able to install the sqlite node!

Thank you so much.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [15 August 2021 21:13 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/13 "2021-08-15T21:13:02Z")

</div>

good but .. the above steps were by no means a way of installing/updating the sqlite node.  
It was just a way to test whether the sqlite node would work with a newer sqlite3 dependency 5.0.2

Better wait for a proper update of the `node-red-node-sqlite` node unless you want to do some tests also so Dave can have some feedback.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [14 October 2021 21:13 UTC](https://discourse.nodered.org/t/not-able-to-install-sqlite/49745/14 "2021-10-14T21:13:03Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.