Help getting this working with Electron?

[Wiff3r]

I have spent several days trying to get an app that uses better-sqlite3 working with Electron and always get this:

*** Error: The module '\?...\better-sqlite3\build\Release\better_sqlite3.node'
was compiled against a different Node.js version using NODE_MODULE_VERSION 108. This version of Node.js requires
NODE_MODULE_VERSION 121. Please try re-compiling or re-installing the module

I understand what the problem is but I've tried every single solution I could find on the web and nothing fixes it.

Has anyone got this working in Windows 10? I am not tied to any version of Node or Electron. I can completely reinstall everything if necessary.

Can someone who has this working please tell me what version of Electron, Node and Better-sqlite3 you are using?

[Wiff3r]

I have no idea if this is what fixed it, but I removed better-sqlite3 using npm and then installed it with --save instead of --save-dev and it works now. I understand the difference but I don't know why this would fix it.

I tried so many other things that it may have been a combination of those things, but it didn't work the last time I tried a few days ago and it did after the above.

[mceachen]

This is expected. Anything your application will need during production runtime must be in the dependencies section of your package.json (not the devDependencies section).

Here's a reasonable summary of the different sections: https://stackoverflow.com/a/22004559/1268016

[Wiff3r]

Ok, thanks. Apparently i didn't fully understand the difference.

[mceachen]

(They certainly aren't that well documented! I had to resort to a StackOverflow post!)