I get an error when connecting to sqlite3 database

Question

I get an error when connecting to the database sqlite3.

This is my code.

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

db.serialize(function(){

    dbb.run("create table user (id int, db text)");
    var stmt = db.prepare("insert into user values(?,?)");
    for(var i=0; i<10; i++){

        var d = new Date();
        var n = d.toLocateTimeString();
        stmt.run(i,n);

    }   
    stmt.finalize();

    db.each("select id, dt from user",function(err,row){
        console.log("user id:"+row.id,row.dt);
    });
});
db.close();

Error:

Unprepared error: cannot find module 'path_to_project \ node_modules \ sqlite3 \ lib \ binding \ electron-v1.4-win32-ia32 \ node_sqlite3.node'

When I register this folder node_modules\sqlite3\lib\binding, it has a folder and file type node-v48-win32-ia32\node_sqlite3.nodeinstead electron-v1.4-win32-ia32\node_sqlite3.node.

Someone suggested that I change the name of the folder node-v48-win32-ia32to electron-v1.4-win32-ia32. Then it will work. But it returns another error

ELECTRON_ASAR.js: 173 Error during collection: the system cannot find the message text for message number 0x% 1 in the message file for% 2. \? \ Path_to_project \ node_modules \ sqlite3 \ Lib \ binding \ electron-v1.4-win32-IA32 \ node_sqlite3.node

- ? , .

Answer 1

,

:

npm install --save-dev electron-rebuild npm install --save-dev electron-prebuilt

package.json script:

"rebuild": "electron-rebuild -f -w sqlite3 -v 1.X"

npm run rebuild

, -v , 1.2, 1.4 1.6

Answer 2

, ,

npm install --save-dev electron-rebuild

package.json script:

"rebuild": "electron-rebuild -f -w sqlite3 -v 1.7" // for version 1.7

, .