Node-sqlite3: Module not found: Error: Can't resolve 'node-pre-gyp'

Created on 15 Nov 2017 · 24Comments · Source: mapbox/node-sqlite3

ERROR in sqlite3/lib/sqlite3.js
Module not found: Error: Can't resolve 'node-pre-gyp' in

Source

RobertRajcool

Most helpful comment

after install this package node-pre-gyp
getting lot of error

WARNING in ./~/node-pre-gyp/lib/util/compile.js
Module not found: Error: Can't resolve 'npm' in '/home/robert/electron/angular2-electron/node_modules/node-pre-gyp/lib/util'
@ ./~/node-pre-gyp/lib/util/compile.js 39:27-49
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

WARNING in ./~/node-gyp/lib/Find-VS2017.cs
Module parse failed: /home/robert/electron/angular2-electron/node_modules/node-gyp/lib/Find-VS2017.cs Unexpected token (7:6)
You may need an appropriate loader to handle this file type.
| // Usage:
| // powershell -ExecutionPolicy Unrestricted -Version "2.0" -Command "&{Add-Type -Path Find-VS2017.cs; [VisualStudioConfiguration.Main]::Query()}"
| using System;
| using System.Text;
| using System.Runtime.InteropServices;
@ ./~/node-gyp/lib ^./.$
@ ./~/node-gyp/lib/node-gyp.js
@ ./~/node-pre-gyp/lib/util/compile.js
@ ./~/node-pre-gyp/lib ^./.$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

WARNING in ./~/sqlite3/lib/sqlite3.js
4:14-35 Critical dependency: the request of a dependency is an expression

WARNING in ./~/node-pre-gyp/lib/pre-binding.js
19:22-48 Critical dependency: the request of a dependency is an expression

WARNING in ./~/node-pre-gyp/lib/util/versioning.js
16:20-67 Critical dependency: the request of a dependency is an expression

ERROR in ./~/node-pre-gyp/lib/info.js
Module not found: Error: Can't resolve 'aws-sdk' in '/home/robert/electron/angular2-electron/node_modules/node-pre-gyp/lib'
@ ./~/node-pre-gyp/lib/info.js 14:14-32
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-pre-gyp/lib/publish.js
Module not found: Error: Can't resolve 'aws-sdk' in '/home/robert/electron/angular2-electron/node_modules/node-pre-gyp/lib'
@ ./~/node-pre-gyp/lib/publish.js 17:14-32
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-pre-gyp/lib/unpublish.js
Module not found: Error: Can't resolve 'aws-sdk' in '/home/robert/electron/angular2-electron/node_modules/node-pre-gyp/lib'
@ ./~/node-pre-gyp/lib/unpublish.js 15:14-32
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-pre-gyp/lib/testbinary.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/node-pre-gyp/lib'
@ ./~/node-pre-gyp/lib/testbinary.js 10:9-33
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-pre-gyp/lib/util/compile.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/node-pre-gyp/lib/util'
@ ./~/node-pre-gyp/lib/util/compile.js 9:9-33
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/detect-libc/lib/detect-libc.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/detect-libc/lib'
@ ./~/detect-libc/lib/detect-libc.js 4:16-40
@ ./~/node-pre-gyp/lib/util/versioning.js
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-gyp/lib/node-gyp.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/node-gyp/lib'
@ ./~/node-gyp/lib/node-gyp.js 16:20-44
@ ./~/node-pre-gyp/lib/util/compile.js
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/osenv/osenv.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/osenv'
@ ./~/osenv/osenv.js 3:11-35
@ ./~/nopt/lib/nopt.js
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-gyp/lib/node-gyp.js
Module not found: Error: Can't resolve '../package' in '/home/robert/electron/angular2-electron/node_modules/node-gyp/lib'
@ ./~/node-gyp/lib/node-gyp.js 67:16-37
@ ./~/node-pre-gyp/lib/util/compile.js
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-gyp/lib/build.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/node-gyp/lib'
@ ./~/node-gyp/lib/build.js 14:11-35
@ ./~/node-gyp/lib ^./.$
@ ./~/node-gyp/lib/node-gyp.js
@ ./~/node-pre-gyp/lib/util/compile.js
@ ./~/node-pre-gyp/lib ^./.$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-gyp/lib/configure.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/node-gyp/lib'
@ ./~/node-gyp/lib/configure.js 19:9-33
@ ./~/node-gyp/lib ^./.$
@ ./~/node-gyp/lib/node-gyp.js
@ ./~/node-pre-gyp/lib/util/compile.js
@ ./~/node-pre-gyp/lib ^./.$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/node-gyp/lib/find-vs2017.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/node-gyp/lib'
@ ./~/node-gyp/lib/find-vs2017.js 2:15-39
@ ./~/node-gyp/lib ^./.$
@ ./~/node-gyp/lib/node-gyp.js
@ ./~/node-pre-gyp/lib/util/compile.js
@ ./~/node-pre-gyp/lib ^./.$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

ERROR in ./~/uid-number/uid-number.js
Module not found: Error: Can't resolve 'child_process' in '/home/robert/electron/angular2-electron/node_modules/uid-number'
@ ./~/uid-number/uid-number.js 9:20-44
@ ./~/tar-pack/index.js
@ ./~/node-pre-gyp/lib/package.js
@ ./~/node-pre-gyp/lib ^./.*$
@ ./~/node-pre-gyp/lib/node-pre-gyp.js
@ ./~/sqlite3/lib/sqlite3.js
@ ./src/app/login/login.component.ts
@ ./src/app/app.module.ts
@ ./src/main.ts
@ multi webpack-dev-server/client?http://localhost:4200/ ./src/main.ts

RobertRajcool on 15 Nov 2017

👍9 👀1

All 24 comments

Can help me!!!

RobertRajcool on 15 Nov 2017

npm install node-pre-gyp

benschool on 15 Nov 2017

after install this package node-pre-gyp
getting lot of error

WARNING in ./~/sqlite3/lib/sqlite3.js
4:14-35 Critical dependency: the request of a dependency is an expression

WARNING in ./~/node-pre-gyp/lib/pre-binding.js
19:22-48 Critical dependency: the request of a dependency is an expression

WARNING in ./~/node-pre-gyp/lib/util/versioning.js
16:20-67 Critical dependency: the request of a dependency is an expression

RobertRajcool on 15 Nov 2017

👍9 👀1

Do you still have this issue? This seems to be a Node configuration issue. Unless you can show how to reproduce this on a recent Node install, I propose that you close this issue

wmertens on 26 Dec 2017

I have this issue too. @RobertRajcool @wmertens any proposed solutions?

gitsana on 26 Jan 2018

Seeing how you're trying to build on windows, did you install the toolset?

npm install --global --production windows-build-tools

On Fri, Jan 26, 2018, 9:25 PM Sana, notifications@github.com wrote:

I have this issue too. @RobertRajcool https://github.com/robertrajcool
@wmertens https://github.com/wmertens any proposed solutions?

—
You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub
https://github.com/mapbox/node-sqlite3/issues/909#issuecomment-360895081,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AADWlrjcNVjVFwFEQBxYOt3D7gtEEMAyks5tOjSvgaJpZM4QfI5u
.

wmertens on 29 Jan 2018

I saw this child_process error elsewhere: it was due to the dev using a module in a webpack build that imported child_process somewhere. Browsers cannot use node APIs, so be careful to not include it anywhere.

wmertens on 1 Feb 2018

I had failed to build sqlite3 for thousand times no matter how, for the aws-sdk relys on child_process so every time you require('sqlite3') on client side it could not be resolved.

Luckily, I found an awesome module can work like a charm on both client or server side - sql.js created by the emscripten's author.

If you are still in troubles with integrating electron and sqlite, you should have a try :)

marswong on 3 Feb 2018

You could alias child_process to a module that fakes it all. I wonder how
you can use aws-sdk on the client side though, if it relies on
child_process.

On Sat, Feb 3, 2018, 10:25 AM Mars Wong, notifications@github.com wrote:

I had failed to build sqlite3 for thousand times no matter how, for the
aws-sdk relys on child_process so every time you require('sqlite3') on
client side it could not be resolved.

Luckily, I found an awesome module can work like a charm on both client or
server side - sql.js https://github.com/kripken/sql.js created by the
emscripten's author.

If you are still in troubles with integrating electron and sqlite, you
should have a try :)

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/mapbox/node-sqlite3/issues/909#issuecomment-362793279,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AADWlnXqs9dajIb8PLigwtAXGBtD5WJIks5tRCYLgaJpZM4QfI5u
.

wmertens on 3 Feb 2018

I have same problem. On Windows. Using electron. Exact error is:

./node_modules/sqlite3/node_modules/node-pre-gyp/lib/info.js
Module not found: Can't resolve 'aws-sdk' in 'C:\Users\alexa\kapla4\node_modules\sqlite3\node_modules\node-pre-gyp\lib'

npm install --global --production windows-build-tools is installed.

child_process is only used node-side in my electron project to start electron after create-react-app has started:

const net = require('net')
const port = process.env.PORT ? process.env.PORT - 100 : 5000

process.env.ELECTRON_START_URL = `http://localhost:${port}`

const client = new net.Socket()

let startedElectron = false
const tryConnection = () =>
  client.connect({ port: port }, () => {
    client.end()
    if (!startedElectron) {
      console.log('starting electron')
      startedElectron = true
      const exec = require('child_process').exec
      exec('yarn run electron')
    }
  })

tryConnection()

client.on('error', error => {
  setTimeout(tryConnection, 1000)
})

The exact same project structure and configuration works flawlessly in another project created yesterday that does not use native modules i.e. sqlite3.

barbalex on 4 Apr 2018

👍4

@barbalex I'm getting the exact same error message when trying to use Sequelize (which depends on sqlite3) together with Electron, any clue how to solve this?

axelkennedal on 9 Oct 2018

👍1

@axelkennedal I ended up not using create-react-app but instead electron-react-boilerplate which solves the problem by using another package.json file - somehow...

barbalex on 9 Oct 2018

😕1

@barbalex I'm also getting same error message with Sequelize, irritating, i'm not using sqlLite3.

dstrawsb on 17 Oct 2018

I'm getting this problem with fsevents on a Mac. Cannot find a solution.

mnmpeterson on 1 Feb 2019

@mnmpeterson try deleting node_modules, package-lock.json and/or yarn.lock, and install again

wmertens on 2 Feb 2019

👎6

Did that, same problem. This is on an angularjs 1.6 project. On an angular 6.x project sfevents will download and compile what it needs from node-gyp but won’t do the same on my angularjs projects.

mnmpeterson on 2 Feb 2019

For what its worth — I've run into the same problem. Deleting node_modules and lock files doesnt help, nor does adding node-pre-gyp globally. I think I too will use the other boilerplate

askogrand on 26 Feb 2019

If you are using electron, I used the package "electron-rebuild" to fix this.
I ran the command "./node_modules/.bin/electron-rebuild -f -w sqlite3"
To use sqlite, use "const sqlite = window.require('sqlite3');"

WilliamC07 on 11 Aug 2019

👍2

hi all, I am facing the same issue on Mac. Is anyone able to solve this problem?
I tried almost all solution available. Still no luck.

For what its worth — I've run into the same problem. Deleting node_modules and lock files doesnt help, nor does adding node-pre-gyp globally. I think I too will use the other boilerplate

Hey, Were you able to fix this issue after using boilerplate code and SQLite? curious to know :)

mayurssoni2456 on 9 Oct 2019

This problem bothered me for three days, and now it's finally solved
Reference resources
https://github.com/mapbox/node-sqlite3/issues/1029#issuecomment-414116796

My solution:

  output: {
    path: config.build.assetsRoot,
    filename: '[name].js',
    publicPath: process.env.NODE_ENV === 'production'
      ? config.build.assetsPublicPath
      : config.dev.assetsPublicPath,
      libraryTarget: 'commonjs2'
  },
  externals: {
      sqlite3: 'sqlite3'
  }

important code
libraryTarget: 'commonjs2'
sqlite3: 'sqlite3'

If you solve this problem because of my solution, please share it with those who need help. And use this link。 :)

feng005211 on 22 Nov 2019

👍4 🎉1

This was happening to me because I was pointing to the wrong dependency

in my case, it was bcrypt that was causing the issue

error received when using :
const bcrypt = require('bcrypt')

error fixed when using :
const bcrypt = require('bcryptjs')

Jclyoung on 15 Jan 2020

👍6

Not sure why this was closed. Issue still exists with node-sqlite3 built from HEAD at April 24th 2020.

xtfer on 24 Apr 2020

👍8

Thanks @Jclyoung

const bcrypt = require('bcryptjs')

This was helpful to me

rajtussspacetech on 13 Sep 2020

for webpack users trying to bundle sqlite3; there may be a better way to do this, but you can override the new sqlite3-binding.js with resolve and point to a different file.

resolve: {
  alias: {
    [path.join(__dirname, 'node_modules/sqlite3/lib/sqlite3-binding.js')]: path.join(__dirname, 'path/to/local/sqlite3-binding.js')
  }
}

path/to/local/sqlite3-binding.js:

var binding = require('bindings')('node_sqlite3');
module.exports = exports = binding;

this approach requires the bindings package.

npm install bindings --save-dev

note: you will have to copy the node_sqlite3.node file to specified directories

firien on 23 Nov 2020

Was this page helpful?

0 / 5 - 0 ratings

Related issues

Failed at the [email protected] install script.

royeradames · 20Comments

node v10.x support

springmeyer · 29Comments

npm install fails

hersoncruz · 27Comments

403 fetching precompiled binary

jpillora · 18Comments

Error: Cannot find module node_modules/sqlite3/lib/binding/node-v57-linux-x64/node_sqlite3.node

Thavaprakash · 31Comments