In my electron app I have installed sqlite3 via npm
npm install sqlite3
But once i try to interact with the database it cant find the database, here is the log:
Uncaught Error: Cannot find module 'D:\play\electron-quick-start\node_modules\sqlite3\lib\binding\electron-v1.3-win32-x64\node_sqlite3.node'
Here is 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 in this way:
npm install sqlite3 --build-from-source
but it fails to install!
Also, i am using Python3. How do you install a module to work with electron?
1: Include rebuild in Package.json file and install npm electron-rebuild
2: install python 2.7 and add its path to environmental variable e.g C:\Python27;
3: npm INSTALL and then npm run rebuild
You have to build this native module with Electron based configurations.
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
This is assuming you have the very latest version of electron. You can change the config to match your electron version.
Firstly:
npm install electron-rebuild
then try this several times:
./node_modules/.bin/electron-rebuild -w sqlite3 -p