sjmelia / electron-boilerplate-sqlite Goto Github PK

Truly minimal Electron app with SQLite support

JavaScript 53.80% HTML 46.20%

electron-boilerplate-sqlite's Introduction

electron-boilerplate-sqlite

Truly tiny boilerplate for an Electron app that includes SQLite support. See the blog post for more.

git clone https://github.com/sjmelia/electron-boilerplate-sqlite.git
cd electron-boilerplate-sqlite
npm install
npm start

Building a release package

Releases can only be built on the target platform.

npm run release

Using native modules

If you wish to use native modules, you must run npm run postinstall after first install of the module.

Thanks to...

Primary inspiration: https://github.com/szwacz/electron-boilerplate
SQLite JS: https://github.com/bytheway/electron-sqlite3/

electron-boilerplate-sqlite's People

Contributors

Stargazers

Watchers

electron-boilerplate-sqlite's Issues

npm install giving lot of errors

it throws so many errors, please try and let me know if it works at your end, in my side it says node-gyp errors, unable to download and what not.

I have tried with alternate internet connection, but problem is same.

It actually worked, then it didn't

Hi! first of all, thank you for this small but wonderful boilerplate.

I am April, I am still a student and I am new to electron, I basically came from the background of web development. I have been trying to do this for almost 8 hours now. I followed your instructions and ran the app for the first time, it worked nicely.

I was wondering what I was doing wrong? because in my experience, I have failed to integrate sqlite3 with electron and opened the TryGhost/node-sqlite3#838.

my first experience was using node 6, the module seems to install, but opening the window I get:

module.js:472 Uncaught Error: Cannot find module 'C:\Users\aprilpineda\Documents\projects\desktop\experiments\2-sample\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node'
    at Module._resolveFilename (module.js:470:15)
    at Function.Module._resolveFilename (C:\Users\aprilpineda\Documents\projects\desktop\experiments\2-sample\node_modules\electron\dist\resources\electron.asar\common\reset-search-paths.js:35:12)
    at Function.Module._load (module.js:418:25)
    at Module.require (module.js:498:17)
    at require (internal/module.js:20:19)
    at Object.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\2-sample\node_modules\sqlite3\lib\sqlite3.js:4:15)
    at Object.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\2-sample\node_modules\sqlite3\lib\sqlite3.js:190:3)
    at Module._compile (module.js:571:32)
    at Object.Module._extensions..js (module.js:580:10)
    at Module.load (module.js:488:32)

then I upgraded to node 8.1.2 and installed node-gyp globally then installed sqlite3 again (in a different project now, I removed the previous one.) and I got this:

npm install --save sqlite3

> [email protected] install C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3
> node-pre-gyp install --fallback-to-build

node-pre-gyp info it worked if it ends with ok
node-pre-gyp verb cli [ 'C:\\Program Files\\nodejs\\node.exe',
node-pre-gyp verb cli   'C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\experiments\\1-testproject\\node_modules\
\sqlite3\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp',
node-pre-gyp verb cli   'install',
node-pre-gyp verb cli   '--fallback-to-build' ]
node-pre-gyp info using [email protected]
node-pre-gyp info using [email protected] | win32 | x64
node-pre-gyp verb command install []
node-pre-gyp info check checked for "C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modu
les\sqlite3\lib\binding\node-v57-win32-x64\node_sqlite3.node" (not found)
node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v57-win32-x64.tar.gz
node-pre-gyp http 200 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v57-win32-x64.tar.gz
node-pre-gyp info install unpacking node_sqlite3.node
node-pre-gyp ERR! Tried to download(undefined): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v57-win3
2-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v57 ABI) (falling back to source c
ompile with node-gyp)
node-pre-gyp http read ECONNRESET
node-pre-gyp verb command build [ 'rebuild' ]
Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
  unpack_sqlite_dep
  sqlite3.c
  win_delay_load_hook.cc
  sqlite3.vcxproj -> C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\bui
  ld\Release\\sqlite3.lib
  database.cc
  node_sqlite3.cc
  statement.cc
  win_delay_load_hook.cc
..\src\database.cc(133): warning C4996: 'v8::Object::ForceSet': was declared deprecated [C:\Users\aprilpineda\Documents
\projects\desktop\experiments\1-testproject\node_modules\sqlite3\build\node_sqlite3.vcxproj]
  c:\users\aprilpineda\.node-gyp\8.1.2\include\node\v8.h(2951): note: see declaration of 'v8::Object::ForceSet'
..\src\statement.cc(103): warning C4996: 'v8::Object::ForceSet': was declared deprecated..\src\database.cc(134): warnin
g C4996: 'v8::Object::ForceSet': was declared deprecated [C:\Users\aprilpineda\Documents\projects\desktop\experiments\1
-testproject\node_modules\sqlite3\build\node_sqlite3.vcxproj]

  c:\users\aprilpineda\.node-gyp\8.1.2\include\node\v8.h(2951): note: see declaration of 'v8::Object::ForceSet'
  c:\users\aprilpineda\.node-gyp\8.1.2\include\node\v8.h(2951): note: see declaration of 'v8::Object::ForceSet'
..\src\statement.cc(277): warning C4244: 'argument': conversion from 'int64_t' to 'int', possible loss of data [C:\User
s\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\build\node_sqlite3.vcxproj]
c:\users\aprilpineda\documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\node_modules\nan\nan_new
.h(208): warning C4244: 'argument': conversion from 'sqlite3_int64' to 'double', possible loss of data (compiling sourc
e file ..\src\statement.cc) [C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sql
ite3\build\node_sqlite3.vcxproj]
  ..\src\statement.cc(479): note: see reference to function template instantiation 'v8::Local<v8::Number> Nan::New<v8::
  Number,sqlite3_int64>(A0)' being compiled
          with
          [
              A0=sqlite3_int64
          ]
c:\users\aprilpineda\documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\node_modules\nan\nan_new
.h(208): warning C4244: 'argument': conversion from 'sqlite3_int64' to 'double', possible loss of data (compiling sourc
e file ..\src\database.cc) [C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqli
te3\build\node_sqlite3.vcxproj]
  ..\src\database.cc(502): note: see reference to function template instantiation 'v8::Local<v8::Number> Nan::New<v8::N
  umber,sqlite3_int64>(A0)' being compiled
          with
          [
              A0=sqlite3_int64
          ]
C:\Users\aprilpineda\.node-gyp\8.1.2\x64\node.lib : fatal error LNK1127: library is corrupt [C:\Users\aprilpineda\Docum
ents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\build\node_sqlite3.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\nod
e_modules\node-gyp\lib\build.js:258:23)
gyp ERR! stack     at emitTwo (events.js:125:13)
gyp ERR! stack     at ChildProcess.emit (events.js:213:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:197:12)
gyp ERR! System Windows_NT 10.0.15063
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\experiment
s\\1-testproject\\node_modules\\node-gyp\\bin\\node-gyp.js" "build" "--fallback-to-build" "--module=C:\\Users\\aprilpine
da\\Documents\\projects\\desktop\\experiments\\1-testproject\\node_modules\\sqlite3\\lib\\binding\\node-v57-win32-x64\\n
ode_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\expe
riments\\1-testproject\\node_modules\\sqlite3\\lib\\binding\\node-v57-win32-x64"
gyp ERR! cwd C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3
gyp ERR! node -v v8.1.2
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\aprilpineda\Documents\projec
ts\desktop\experiments\1-testproject\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\a
prilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\node-v57-win32-x64\node
_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-tes
tproject\node_modules\sqlite3\lib\binding\node-v57-win32-x64' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-t
estproject\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp ERR! stack     at emitTwo (events.js:125:13)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:213:7)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:897:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:208:5)
node-pre-gyp ERR! System Windows_NT 10.0.15063
node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\e
xperiments\\1-testproject\\node_modules\\sqlite3\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-t
o-build"
node-pre-gyp ERR! cwd C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3
node-pre-gyp ERR! node -v v8.1.2
node-pre-gyp ERR! node-pre-gyp -v v0.6.31
node-pre-gyp ERR! not ok
Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testpr
oject\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\aprilpineda\Documents\projects\d
esktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\node-v57-win32-x64\node_sqlite3.node --module_name=nod
e_sqlite3 --module_path=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\l
ib\binding\node-v57-win32-x64' (1)
npm WARN [email protected] No description

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\aprilpineda\AppData\Roaming\npm-cache\_logs\2017-06-27T15_10_12_645Z-debug.log

In your boilerplate, when I did an npm update then npm start I get the same error saying that the module was not found:

Uncaught Error: Cannot find module 'C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node'
    at Module._resolveFilename (module.js:470:15)
    at Function.Module._resolveFilename (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron\dist\resources\electron.asar\common\reset-search-paths.js:35:12)
    at Function.Module._load (module.js:418:25)
    at Module.require (module.js:498:17)
    at require (internal/module.js:20:19)
    at Object.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\sqlite3.js:4:15)
    at Object.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\sqlite3.js:190:3)
    at Module._compile (module.js:571:32)
    at Object.Module._extensions..js (module.js:580:10)
    at Module.load (module.js:488:32)

then I thought of building it again so I did a npm run postinstall and got this output:

npm run postinstall

> [email protected] postinstall C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject
> install-app-deps

Rebuilding native production dependencies for win32:x64
Error: C:\Program Files\nodejs\node.exe exited with code 1
Output:

> [email protected] install C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3
> node-pre-gyp install --fallback-to-build


C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" clean )  else (node "" clean )

C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" configure --fallback-to-build --module=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64 --python=C:\Users\aprilpineda\.windows-build-tools\python27\python.exe --msvs_version=2015 )  else (node "" configure --fallback-to-build --module=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64 --python=C:\Users\aprilpineda\.windows-build-tools\python27\python.exe --msvs_version=2015 )
Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64 --python=C:\Users\aprilpineda\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)

Error output:
node-pre-gyp info it worked if it ends with ok
node-pre-gyp verb cli [ 'C:\\Program Files\\nodejs\\node.exe',
node-pre-gyp verb cli   'C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\experiments\\1-testproject\\node_modules\\sqlite3\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp',
node-pre-gyp verb cli   'install',
node-pre-gyp verb cli   '--fallback-to-build' ]
node-pre-gyp info using [email protected]
node-pre-gyp info using [email protected] | win32 | x64
node-pre-gyp verb command install []
node-pre-gyp info build requesting source compile
node-pre-gyp verb command build [ 'rebuild' ]
gyp WARN install got an error, rolling back install
gyp ERR! configure error
gyp ERR! stack Error: read ECONNRESET
gyp ERR! stack     at exports._errnoException (util.js:1016:11)
gyp ERR! stack     at TLSWrap.onread (net.js:609:25)
gyp ERR! System Windows_NT 10.0.15063
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\experiments\\1-testproject\\node_modules\\sqlite3\\lib\\binding\\electron-v1.7-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\experiments\\1-testproject\\node_modules\\sqlite3\\lib\\binding\\electron-v1.7-win32-x64" "--python=C:\\Users\\aprilpineda\\.windows-build-tools\\python27\\python.exe" "--msvs_version=2015"
gyp ERR! cwd C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3
gyp ERR! node -v v8.1.2
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64 --python=C:\Users\aprilpineda\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp ERR! stack     at emitTwo (events.js:125:13)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:213:7)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:897:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:208:5)
node-pre-gyp ERR! System Windows_NT 10.0.15063
node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\aprilpineda\\Documents\\projects\\desktop\\experiments\\1-testproject\\node_modules\\sqlite3\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\sqlite3
node-pre-gyp ERR! node -v v8.1.2
node-pre-gyp ERR! node-pre-gyp -v v0.6.31
node-pre-gyp ERR! not ok
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\aprilpineda\AppData\Roaming\npm-cache\_logs\2017-06-27T16_07_34_109Z-debug.log

    at ChildProcess.childProcess.once.code (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\src\util\util.ts:136:14)
    at Object.onceWrapper (events.js:318:30)
    at emitTwo (events.js:125:13)
    at ChildProcess.emit (events.js:213:7)
    at maybeClose (internal/child_process.js:897:16)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:208:5)
From previous event:
    at spawn (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\src\util\util.ts:99:3)
    at C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\src\yarn.ts:146:11
From previous event:
    at rebuild (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\out\yarn.js:81:22)
    at C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\src\yarn.ts:15:11
    at Generator.next (<anonymous>)
    at runCallback (timers.js:800:20)
    at tryOnImmediate (timers.js:762:5)
    at processImmediate [as _immediateCallback] (timers.js:733:5)
From previous event:
    at installOrRebuild (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\out\yarn.js:33:21)
    at C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\src\cli\install-app-deps.ts:34:2
    at Generator.next (<anonymous>)
From previous event:
    at main (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\out\cli\install-app-deps.js:36:21)
    at Object.<anonymous> (C:\Users\aprilpineda\Documents\projects\desktop\experiments\1-testproject\node_modules\electron-builder\out\cli\install-app-deps.js:76:1)
    at Module._compile (module.js:569:30)
    at Object.Module._extensions..js (module.js:580:10)
    at Module.load (module.js:503:32)
    at tryModuleLoad (module.js:466:12)
    at Function.Module._load (module.js:458:3)
    at Function.Module.runMain (module.js:605:10)
    at startup (bootstrap_node.js:158:16)
    at bootstrap_node.js:575:3
npm ERR! code ELIFECYCLE
npm ERR! errno 4294967295
npm ERR! [email protected] postinstall: `install-app-deps`
npm ERR! Exit status 4294967295
npm ERR!
npm ERR! Failed at the [email protected] postinstall script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\aprilpineda\AppData\Roaming\npm-cache\_logs\2017-06-27T16_07_34_282Z-debug.log

I was hoping if you can enlighten me.

here is the package.json I changed it a bit just to experiment and see how it affects things.

{
  "name": "1-testproject",
  "description": "",
  "version": "1.0.0",
  "author": "April Mintac Pineda <[email protected]>",
  "license": "UNLICENSED",
  "main": "app/app.js",
  "build": {
    "appId": "com.example.electron-boilerplate-sqlite",
    "files": [
      "app/**/*",
      "node_modules/**/*",
      "package.json"
    ]
  },
  "scripts": {
    "postinstall": "install-app-deps",
    "start": "electron .",
    "test": "echo \"Error: no test specified\" && exit 1",
    "release": "build"
  },
  "dependencies": {
    "sqlite3": "^3.1.8"
  },
  "devDependencies": {
    "electron": "^1.7.3",
    "electron-builder": "^10.8.1"
  }
}

SQLite won't install properly

When running npm install after cloning your repo I get the following errors:

> [email protected] install /Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3
> node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! UNCAUGHT EXCEPTION
node-pre-gyp ERR! stack Error: Empty target version is not supported if electron is the target.
node-pre-gyp ERR! stack     at get_electron_abi (/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/versioning.js:34:15)
node-pre-gyp ERR! stack     at get_runtime_abi (/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/versioning.js:81:16)
node-pre-gyp ERR! stack     at Object.module.exports.evaluate (/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/versioning.js:292:19)
node-pre-gyp ERR! stack     at handle_gyp_opts (/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/handle_gyp_opts.js:54:27)
node-pre-gyp ERR! stack     at configure (/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/configure.js:11:5)
node-pre-gyp ERR! stack     at /Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/build.js:35:13
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/compile.js:85:9)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:182:13)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:962:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:251:5)
node-pre-gyp ERR! System Darwin 18.2.0
node-pre-gyp ERR! command "/usr/local/Cellar/node/10.11.0/bin/node" "/Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd /Users/axelkennedal/SyncBoi/Programmering/Electron/electron-boilerplate-sqlite/node_modules/sqlite3
node-pre-gyp ERR! node -v v10.11.0
node-pre-gyp ERR! node-pre-gyp -v v0.6.38
node-pre-gyp ERR! This is a bug in `node-pre-gyp`.
node-pre-gyp ERR! Try to update node-pre-gyp and file an issue if it does not help:
node-pre-gyp ERR!     <https://github.com/mapbox/node-pre-gyp/issues>
npm WARN [email protected] No repository field.
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: [email protected] (node_modules/7zip-bin-win):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for [email protected]: wanted {"os":"win32","arch":"any"} (current: {"os":"darwin","arch":"x64"})
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: [email protected] (node_modules/7zip-bin-linux):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for [email protected]: wanted {"os":"linux","arch":"any"} (current: {"os":"darwin","arch":"x64"})

npm ERR! code ELIFECYCLE
npm ERR! errno 7
npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 7
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

I'm running this on macOS Mojave.

npm install fails

npm i fails because sqlite3 v3 is no longer available

npm install error

Hi!
I run "npm install" and just failed.
here is the log:

Error output:
gyp WARN install got an error, rolling back install
gyp ERR! configure error
gyp ERR! stack Error: read ECONNRESET
gyp ERR! stack at exports._errnoException (util.js:1020:11)
gyp ERR! stack at TLSWrap.onread (net.js:568:26)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "E:\js\node\node.exe" "E:\js\node\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64"
gyp ERR! cwd E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3
gyp ERR! node -v v6.11.5
gyp ERR! node-gyp -v v3.4.0
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3\lib\binding\electron-v1.7-win32-x64' (1)
node-pre-gyp ERR! stack at ChildProcess. (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp ERR! stack at emitTwo (events.js:106:13)
node-pre-gyp ERR! stack at ChildProcess.emit (events.js:191:7)
node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:920:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:230:5)
node-pre-gyp ERR! System Windows_NT 6.1.7601
node-pre-gyp ERR! command "E:\js\node\node.exe" "E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\sqlite3
node-pre-gyp ERR! node -v v6.11.5
node-pre-gyp ERR! node-pre-gyp -v v0.6.38
node-pre-gyp ERR! not ok

npm ERR! Windows_NT 6.1.7601
npm ERR! argv "E:\js\node\node.exe" "E:\js\node\node_modules\npm\bin\npm-cli.js" "rebuild" "sqlite3"
npm ERR! node v6.11.5
npm ERR! npm v3.10.10
npm ERR! code ELIFECYCLE
npm ERR! [email protected] install: node-pre-gyp install --fallback-to-build
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script 'node-pre-gyp install --fallback-to-build'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the sqlite3 package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-pre-gyp install --fallback-to-build
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs sqlite3
npm ERR! Or if that isn't available, you can get their info via:
npm ERR! npm owner ls sqlite3
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR! E:\js\project\sqlite\electron-boilerplate-sqlite\npm-debug.log

at ChildProcess.childProcess.once.code (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\src\util\util.ts:136:14)
at ChildProcess.g (events.js:292:16)
at emitTwo (events.js:106:13)
at ChildProcess.emit (events.js:191:7)
at maybeClose (internal/child_process.js:920:16)
at Process.ChildProcess._handle.onexit (internal/child_process.js:230:5)

From previous event:
at spawn (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\src\util\util.ts:99:3)
at E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\src\yarn.ts:146:11
From previous event:
at rebuild (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\out\yarn.js:81:22)
at E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\src\yarn.ts:15:11
at next (native)
at runCallback (timers.js:672:20)
at tryOnImmediate (timers.js:645:5)
at processImmediate [as _immediateCallback] (timers.js:617:5)
From previous event:
at installOrRebuild (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\out\yarn.js:33:21)
at E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\src\cli\install-app-deps.ts:34:2
at next (native)
From previous event:
at main (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\out\cli\install-app-deps.js:36:21)
at Object. (E:\js\project\sqlite\electron-boilerplate-sqlite\node_modules\electron-builder\out\cli\install-app-deps.js:76:1)
at Module._compile (module.js:570:32)
at Object.Module._extensions..js (module.js:579:10)
at Module.load (module.js:487:32)
at tryModuleLoad (module.js:446:12)
at Function.Module._load (module.js:438:3)
at Module.runMain (module.js:604:10)
at run (bootstrap_node.js:383:7)
at startup (bootstrap_node.js:149:9)
at bootstrap_node.js:496:3

npm ERR! Windows_NT 6.1.7601
npm ERR! argv "E:\js\node\node.exe" "E:\js\node\node_modules\npm\bin\npm-cli.js" "install"
npm ERR! node v6.11.5
npm ERR! npm v3.10.10
npm ERR! code ELIFECYCLE
npm ERR! [email protected] postinstall: install-app-deps
npm ERR! Exit status 4294967295
npm ERR!
npm ERR! Failed at the [email protected] postinstall script 'install-app-deps'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the electron-boilerplate-sqlite package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! install-app-deps
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs electron-boilerplate-sqlite
npm ERR! Or if that isn't available, you can get their info via:
npm ERR! npm owner ls electron-boilerplate-sqlite
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR! E:\js\project\sqlite\electron-boilerplate-sqlite\npm-debug.log

I have Visual Studio 2013, Python 2.7.11, Vue.js 2.5.9, Node 7.9.0, Windows 7, win64.
I don't why it doesn't work.

Fails using webpack

The template works fine when installed as described. However, when adding webpack to the mix, it fails with all sorts of errors.

Any suggestions on how to use this boilerplate in combination with webpack?

Documentation would be good

Howdy,

This a great resource for a baseline electron+sqlite build that I can use to reality check problems with sqlite in my main electron app. But I'm not quite sure what you did here, so I'm not sure how to apply this information to other projects.

I see the example JS calling on sqlite3 in index.html. And I can see these parts of package.json:

`
  "scripts": {
    "postinstall": "install-app-deps",
    "start": "electron .",
    "test": "echo \"Error: no test specified\" && exit 1",
    "release": "build"
  },
  "dependencies": {
    "sqlite3": "^3.1.8"
  },
  "devDependencies": {
    "electron": "^1.4.10",
    "electron-builder": "^10.8.1"
  }
`

Also, you had a note about needing to run-script the postinstall step. Got it.

But aside from that, I'm wondering what the exact differences there were between your code and the starting point, so that I can do approximately the same things in my own app. A git diff would be ideal.

Just an idea.

npm install Doesn't work

Here's the log. The error message doesn't say anything anyway. The last line before the error is Rebuilding native production dependencies for win32:x64

Error: C:\Program Files\nodejs\node.exe exited with code 1
Output:

> [email protected] install C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3
> node-pre-gyp install --fallback-to-build


C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" clean )  else (node "" clean )

C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" configure --fallback-to-build --module=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64 )  else (node "" configure --fallback-to-build --module=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64 )

C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" build --fallback-to-build --module=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64 )  else (node "" build --fallback-to-build --module=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64 )
���̃\�����[�V�������̃v���W�F�N�g�� 1 �x�� 1 �����r���h���܂��B���s�r���h���L���ɂ����ɂ́A"/m" �X�C�b�`���ǉ����Ă��������B
C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V140\Platforms\x64\PlatformToolsets\v140\Toolset.targets(36,5): error MSB8036: The Windows SDK version 8.1 was not found. Install the required version of Windows SDK or change the SDK version in the project property pages or by right-clicking the solution and selecting "Retarget solution". [C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\build\deps\action_before_build.vcxproj]
Failed to execute 'node-gyp.cmd build --fallback-to-build --module=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64' (1)

Error output:
gyp ERR! build error
gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:276:23)
gyp ERR! stack     at emitTwo (events.js:106:13)
gyp ERR! stack     at ChildProcess.emit (events.js:191:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:204:12)
gyp ERR! System Windows_NT 10.0.14393
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "build" "--fallback-to-build" "--module=C:\\Users\\Felo\\Desktop\\electron-boilerplate-sqlite-master\\node_modules\\sqlite3\\lib\\binding\\electron-v1.6-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\Felo\\Desktop\\electron-boilerplate-sqlite-master\\node_modules\\sqlite3\\lib\\binding\\electron-v1.6-win32-x64"
gyp ERR! cwd C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3
gyp ERR! node -v v6.2.0
gyp ERR! node-gyp -v v3.3.1
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute 'node-gyp.cmd build --fallback-to-build --module=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\lib\binding\electron-v1.6-win32-x64' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp ERR! stack     at emitTwo (events.js:106:13)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:191:7)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:850:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:215:5)
node-pre-gyp ERR! System Windows_NT 10.0.14393
node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\Felo\\Desktop\\electron-boilerplate-sqlite-master\\node_modules\\sqlite3\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\sqlite3
node-pre-gyp ERR! node -v v6.2.0
node-pre-gyp ERR! node-pre-gyp -v v0.6.31
node-pre-gyp ERR! not ok

npm ERR! Windows_NT 10.0.14393
npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "rebuild" "sqlite3"
npm ERR! node v6.2.0
npm ERR! npm  v3.8.9
npm ERR! code ELIFECYCLE
npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script 'node-pre-gyp install --fallback-to-build'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the sqlite3 package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node-pre-gyp install --fallback-to-build
npm ERR! You can get information on how to open an issue for this project with:
npm ERR!     npm bugs sqlite3
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!     npm owner ls sqlite3
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR!     C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\npm-debug.log

    at ChildProcess.childProcess.once.code (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\src\util\util.ts:136:14)
    at ChildProcess.g (events.js:286:16)
    at emitTwo (events.js:106:13)
    at ChildProcess.emit (events.js:191:7)
    at maybeClose (internal/child_process.js:850:16)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:215:5)
From previous event:
    at spawn (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\src\util\util.ts:99:3)
    at C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\src\yarn.ts:146:11
From previous event:
    at rebuild (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\out\yarn.js:81:22)
    at C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\src\yarn.ts:15:11
    at next (native)
    at tryOnImmediate (timers.js:543:15)
    at processImmediate [as _immediateCallback] (timers.js:523:5)
From previous event:
    at installOrRebuild (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\out\yarn.js:33:21)
    at C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\src\cli\install-app-deps.ts:34:2
    at next (native)
From previous event:
    at main (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\out\cli\install-app-deps.js:36:21)
    at Object.<anonymous> (C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\node_modules\electron-builder\out\cli\install-app-deps.js:76:1)
    at Module._compile (module.js:541:32)
    at Object.Module._extensions..js (module.js:550:10)
    at Module.load (module.js:458:32)
    at tryModuleLoad (module.js:417:12)
    at Function.Module._load (module.js:409:3)
    at Function.Module.runMain (module.js:575:10)
    at startup (node.js:160:18)
    at node.js:449:3

npm WARN optional Skipping failed optional dependency /7zip-bin/7zip-bin-mac:
npm WARN notsup Not compatible with your operating system or architecture: [email protected]
npm WARN optional Skipping failed optional dependency /7zip-bin/7zip-bin-linux:
npm WARN notsup Not compatible with your operating system or architecture: [email protected]
npm WARN [email protected] No repository field.
npm ERR! Windows_NT 10.0.14393
npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "install"
npm ERR! node v6.2.0
npm ERR! npm  v3.8.9
npm ERR! code ELIFECYCLE
npm ERR! [email protected] postinstall: `install-app-deps`
npm ERR! Exit status 4294967295
npm ERR!
npm ERR! Failed at the [email protected] postinstall script 'install-app-deps'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the electron-boilerplate-sqlite package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     install-app-deps
npm ERR! You can get information on how to open an issue for this project with:
npm ERR!     npm bugs electron-boilerplate-sqlite
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!     npm owner ls electron-boilerplate-sqlite
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR!     C:\Users\Felo\Desktop\electron-boilerplate-sqlite-master\npm-debug.log

How to access existing SQLite file from a built app?

This is my code:

const db_name = 'sqlite.db'; // existing file
const db_path = path.join(__dirname, db_name);
const db = new sqlite3.Database(db_path);

sqlite3 error

you just added sqlite3 but never used it.
I add your project and start it, it work very good but when i add sqlite3 module to app.js I have problem with it

SQLite JS project is gone

Mentor has decided to hide it or simply vanish it

How to see my db?

Hi!
Sorry to bother you.
I just wonder how can i see the data in my sqlite3 ?

For example :
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(':memory:');

Does it mean that I create a db named "memory" ?
In which file I can find it ?
And how can I see the data that I written in the DB ?

BTW, thanks for the answer on my last issues, it does works .

After build not load the template

Hi, [sorry for my english]
i have a project started by this(electron-boiler-sqlite).
this project is composed:

Angularjs
bootstrap (with template gentelella)
express
sqlite

When i run: npm run start ("electron ."), it's all ok
this the result

Contrariwise when i run : npm run release, i have any problem.
The build ends successfully, but when open the project the result is this:

Have you any idea for resolve this problem?

Thank
Jempis

sqlite3 fails with file

I've updated this boilerplate to use the latest, but I'm having an issue where upon release creation, the mac app crashes if a file is used instead of memory. The file gets created, but the app just crashes. :memory: works fine. I expect this is an issue with node-sqlite3 and not this boilerplate, but hope to get a good example of a working implementation for my electron app. The app itself works fine if I do npm start and even works on the mac app if run in a debugger lldb, but for some reason, fails when run normally. I noticed that node-sqlite3 does have a 5.0.1 release, but it hasn't been published to npm and I can't get it to build from source. Tested on both Electron 9 & 10. In any case, I'm struggling with it, so I figured I'd pass the info to bigger brains than I.

This works fine.

var db = new sqlite3.Database(':memory:');

This fails with the release.

var db = new sqlite3.Database('test.db');

Here is the updated package.json.

{
  "name": "electron-boilerplate-sqlite",
  "productName": "Electron boilerplate with sqlite",
  "description": "Starter for your electron + sqlite application",
  "version": "1.0.0",
  "author": "Kolley Kibber <[email protected]>",
  "copyright": "© 2016, Kibber Ltd.",
  "homepage": "http://example.com",
  "license": "MIT",
  "main": "app/app.js",
  "build": {
    "appId": "com.example.electron-boilerplate-sqlite",
    "files": [
      "app/**/*",
      "node_modules/**/*",
      "package.json"
    ]
  },
  "scripts": {
    "postinstall": "electron-builder install-app-deps",
    "start": "electron .",
    "test": "echo \"Error: no test specified\" && exit 1",
    "release": "electron-builder"
  },
  "dependencies": {
    "sqlite3": "^5.0.0"
  },
  "devDependencies": {
    "electron": "^10.1.5",
    "electron-builder": "^22.9.1"
  }
}