Ubuntu 16.04
Node.js 8.12.0
Npm 6.4.1
Cnpm 6.0.0
Electron 3.0.0
sudo apt-get install curl
curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash -
sudo apt-get install -y nodejs
sudo npm install -g cnpm --registry=https://registry.npm.taobao.org
sudo cnpm install -g electron
git clone https://github.com/electron/electron-quick-start
cd electron-quick-start
cnpm install
cnpm start
npm install -g -save node-gyp
cnpm install --save sqlite3
cd node_modules/sqlite3
cnpm install
ls lib/binding/
node-gyp configure --module_name=node_sqlite3 --module_path=../lib/binding/node-v57-linux-x64
node-gyp rebuild --target=3.0.0 --arch=x64 --target_platform=linux --dist-url=https://atom.io/download/atom-shell --module_name=node_sqlite3 --module_path=../lib/binding/node-v57-linux-x64
mv lib/binding/node-v57-linux-x64/ lib/binding/electron-v3.0-linux-x64/
var sqlite3 = require('sqlite3').verbose(); const path = require('path'); var db = new sqlite3.Database(path.join(__dirname, 'database.db'));
db.serialize(function() { db.run("CREATE TABLE IF NOT EXISTS tablename (info TEXT)"); });
db.run("INSERT INTO tablename(info,info2) VALUES ($d1,$d2)",{$d1:"f1",$d2:"f2"},function(err,res){ console.log(err,res,this.lastID); });
db.run("delete from tablename where rowid > 1",function(err,res){ console.log(err,res,this.changes,this.lastID); });
db.run("UPDATE tablename SET info = ? WHERE rowid = ?", [ "bar", 2 ]);
db.get("select * from tablename where rowid=?",[1],function(err,res){ console.log(err,res); });