Help me use Electron!

[JoshuaWise]

Electron Help Thread

This thread is for anyone who needs help using Electron with better-sqlite3.

better-sqlite3 is a Node.js package, not an Electron package. If third parties like Electron decide to do fancy things that happen to break a perfectly functioning Node.js package, it is not an issue with that package. Any issues related to Electron should be reported here. If you're lucky, friendly members of the community may chime in here to help you.

[JoshuaWise]

As a potentially helpful start to this thread, I'd like to contribute that many people have had their issues resolved by using @electron/rebuild.

(Edit by @mceachen: electron-rebuild was renamed to @electron/rebuild)

[jlongster]

I'm using both Electron and Windows so I'm happy to chime in here. I'm still using a custom fork but I think you resolved my PRs a while ago so I need to try master again. I'll let you know what we should document about Electron (at the very least, just like any native module, you do need to rebuild it for electron and electron-rebuild works great)

[JoshuaWise]

@jlongster That's great, the help is much appreciated

[mandaputtra]

I,m still had this error even with electron rebuild

here my package.json

{
  "name": "sqlite-electron",
  "version": "1.0.0",
  "main": "index.js",
  "scripts": {
    "start": "electron .",
    "rebuild": "electron-rebuild -f -w better-sqlite3",
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "description": "",
  "dependencies": {
    "better-sqlite3": "^4.1.4",
    "electron": "^2.0.2"
  },
  "devDependencies": {
    "electron-rebuild": "^1.7.3"
  }
}

OS: Linux Ubuntu Based
node 8.11.1 using nvm

I can help all our projects are using electron and better-sqlite3

this is our read me

/////////////////////////////////////////////
SETUP AND INSTALL MODULES
/////////////////////////////////////////////
better-sqlite3 instructios

npm install -g windows-build-tools(might need to install python and add the dir to the env file in windows)

if that doesnt work install

python 2.7 (not 3)

then below to add to path.
https://www.pythoncentral.io/add-python-to-path-python-is-not-recognized-as-an-internal-or-external-command/

(windows 7 install .net 4.5.1)

go (C:\Users%USERNAME%.windows-build-tools)
run

BuildTools_Full.exe

open BuildTools and click modify

Check VC++ 2015.3 v14.00(v140) toolset for desktop

npm install --save better-sqlite3

npm install --save-dev electron-rebuild

go to terminal in the vs and run

node_modules/.bin/electron-rebuild -f -w better-sqlite3

if you have more than one module that needs building like (bcypt) its best to use

node_modules/.bin/electron-rebuild.

[tracker1]

It may be best to use nvm and set the same node version to match the version in electron... depending on what/how you are running functional/integration testing, you may still need the version against your framework outside electron.

[LucaPizzagalli]

Hello,
I want to display some data using a renderer process and accessing a database; the database is open in the main process. I'm trying to pass the database variable from the main to the renderer using ipcRenderer but when I try to call db.prepare() in the renderer i get the error:
"db.prepare is not a function"

Searching throw stackoverflow it seems that the reason is that Electron's IPC only sends serializable object and Database is not (I'm not really sure about this).

How can I pass the database from the main to the renderer?

[SwiTool]

Where it doesn't work for you even with the windows-build-tools, here is the fix :

• Install Visual Studio Installer
• Modify Visual Studio Build Tools 2017 (or install if you don't have)
• Inside Visual C++ Build Tools, tick VC++ 2015.3 v14.00 (v140) toolset
• Push the Install button (or Modify)
• Retry running npm install better-sqlite3
• Run node_modules/.bin/electron-rebuild -f -w better-sqlite3

And there you go, you can run your app.

[JoshuaWise]

@LucaPizzagalli You can't send database objects across IPC channels, but you can send a filename (string), which you can then use to open the same database within your renderer process.