After some recent adventures with Phonegap (perhaps more on that later) I thought i’d give Electron a go. Any desktop app benefits from a little RDBMS magic, so I wanted to get that prerequisite sorted sharpish – but it was surprisingly difficult to get SQLite integrated into my build.
A repo from Ben Bytheway helped me get something working; but as the default name for the binding output from the native build is for Node; it took quite a lot of fettling to get this working with Electron on Linux. Further browsing drew a blank; but while trying to understand how bundling was going to work I stumbled across Jakub Szwacz’s excellent electron-boilerplate; which uses electron-builder for packaging and includes an explanation of how this can be used to drive the compilation of native modules.
Electron-builder makes it super easy; it’s simply a matter of npm install --save sqlite3 to grab the module; and npm run postinstall to have electron-builder compile any native libraries with the correct names.
So here’s my own boilerplate sample – electron-boilerplate-sqlite – just a no frills example of using SQLite in an Electron app.
Worked like a charm! Thank you!
I used your repo (example code) which gives me an error nothing works I think this could be os problem i’m using windows 10
if there’s any solution then please help me
npm ERR! sqlite3@3.1.8 install: `node-pre-gyp install –fallback-to-build`
It worked! Even though the versions are a bit old now.
Thanks a lot!
Cheers…