CODEWITHSUNDEEP
javascriptnode.jssqlitenpm
Stephen Collins
Stephen Collins

Reputation: 3653

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

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.

Upvotes: 30

Views: 55401

Answers (8)

user23356021
user23356021

Reputation: 1

For me, the root cause was a Dockerfile specifying npm when it needed to be yarn for cross OS compatibility.

Upvotes: 0

Eduardo Cuomo
Eduardo Cuomo

Reputation: 18937

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

Upvotes: 2

Snowcat
Snowcat

Reputation: 526

In case this above has not worked for anyone, here is what worked for me:

sudo apt install node-sqlite3

(I am using Ubuntu with Vscode as editor). It seems installing this node-sqlite3 module was the one that was recognized.

Upvotes: 0

Andrew_1510
Andrew_1510

Reputation: 13526

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.

Upvotes: 1

jamesxiang
jamesxiang

Reputation: 738

To skip searching for pre-compiled binaries, and force a build from source, use

npm install --build-from-source

Upvotes: -1

Demodave
Demodave

Reputation: 6632

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

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

Upvotes: 37

mitesh
mitesh

Reputation: 936

use this:-

npm install sqlite3 --build-from-source

Upvotes: 67

Stephen Collins
Stephen Collins

Reputation: 3653

It seems this is a problem with the sqlite3 npm package itself. There exists a lib\binding\Release\ folder, but not a lib\binding\Debug\ folder. I just created a copy of the Release folder, named it Debug, and all is well.

Upvotes: 0

Related Questions