Electronic application cannot find sqlite3 module

Question

In my electronic application, I installed sqlite3 via npm

npm install sqlite3

But as soon as I try to interact with the database, it cannot find the database, here is the log:

Fault: cannot find module 'D: \ play \ electron-quick start \ node_modules \ sqlite3 \ lib \ binding \ electron-v1.3-win32-x64 \ node_sqlite3.node'

Here is the JS code:

console.log('whooooo');

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('../db/info.db');

db.serialize(function () {
    db.run("CREATE TABLE lorem (info TEXT)");   

    var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
    for (var i = 0; i < 10; i++) {
        stmt.run("Ipsum " + i);
    }
    stmt.finalize();

    db.each("SELECT rowid AS id, info FROM lorem", function (err, row) {
        console.log(row.id + ": " + row.info);
    });
});
db.close();

I also try this way:

npm install sqlite3 --build-from-source

but it cannot be installed!

In addition, I am using Python3. How do you install an electronic module?

Answer 1

Firstly:

npm install electron-rebuild

try a few times:

./node_modules/.bin/electron-rebuild -w sqlite3 -p

Answer 2

Electron.

Try:
1. cd node_modules/sqlite3
2. npm run prepublish
3. node-gyp configure --module_name=node_sqlite3 --module_path=../lib/binding/electron-v1.3-win32-x64
4. node-gyp rebuild --target=1.3.1 --arch=x64 --target_platform=win32 --dist-url=https://atom.io/download/atom-shell --module_name=node_sqlite3 --module_path=../lib/binding/electron-v1.3-win32-x64

, . .

Answer 3

1: Package.json npm electronic-rebuild

{
  "name": "electron-quick-start",
  "version": "1.0.0",
  "description": "A minimal Electron application",
  "main": "main.js",
  "scripts": {
    "start": "electron .",
    "rebuild": "electron-rebuild -f -w sqlite3"
  },
  "repository": "https://github.com/electron/electron-quick-start",
  "keywords": [
    "Electron",
    "quick",
    "start",
    "tutorial",
    "demo"
  ],
  "author": "author",
  "license": "CC0-1.0",
  "devDependencies": {
    "@types/file-saver": "0.0.1",
    "electron": "1.7",
    "electron-rebuild": "^1.6.0"
  },
  "dependencies": {
    "sqlite3": "^3.1.13"
  }
}

2: python 2.7 , C:\Python27;

3: npm ,  npm run rebuild

Answer 4

sqlite3, . electron-rebuild, .

npm i --save-dev electron-rebuild . ˚ electron-rebuild. Ru sqlite3 .

./node_modules/.bin/electron-rebuild -w sqlite3 -p

, npm install, .

Answer 5

. , Windows PC. Mac, , /.

npm install electron-rebuild
./node_modules/.bin/electron-rebuild -w sqlite3 -p