Node.js says it can't load sqlite3 module, but does anyway

Question

I'm working with the new Node.js Tools for Visual Studio and included the sqlite3 npm module. When I call require('sqlite3') it throws the error:

Error: Cannot find module './binding\Debug\node-v11-win32-ia32\node_sqlite3.node'

Odd thing is, when I ignore the error and continue running the code, everything works fine...until the function I'm in returns; then the server crashes.

Has anyone else had this issue? I have a suspicion that it has something to do with the ./binding part, but wouldn't know where to begin in terms of finding out why.

Solution 1

use this:-

npm install sqlite3 --build-from-source

Solution 2

This is what worked for me: https://www.npmjs.com/package/sqlite3

npm install https://github.com/mapbox/node-sqlite3/tarball/master

Solution 3

From: https://github.com/mapbox/node-sqlite3/wiki/Building-On-Windows

1. Install required software:
2. Python 2.x: https://www.python.org/downloads/release/python-2711/
3. Win SDK: http://www.microsoft.com/en-us/download/details.aspx?displayLang=en&id=8279
4. Microsoft Visual Studio 2010+: https://www.microsoft.com/es-es/download/details.aspx?id=48217
5. Build:
6. npm install sqlite
7. npm install
8. node-gyp configure build

Solution 4

I got the kind of problem, my node version is v10.16.3 This globally installed sqlite3 gives error in loading by require('sqlite3')

It been solved by install a sqlite3 local to project.

$ npm install sqlite3

Note without -g option, it works for me.

View more solutions