sqlite - anyone use it?
-
Pretty new to all of this. I was hoping to use sqlite instead of mysql but…
MM can’t find node_sqlite3.node looking in electron-v6.0-linux-arm. In serveronly mode it works fine. Any hints??
-
@bobt it should only run on the node_helper.js side, not in the browser side…
-
Wow - thanks for the quick reply. The db work is in the helper - the require, connect, select. It gets kicked off with socketNotificationReceived. Sends data back with self.sendSocketNotification(“DATA”,self.data);
-
If I just send back data without using the sqlite3 it works too.
-
@bobt so, it works ok?
-
@sdetweil It works with fine serveronly. Gets data from the db and passes it to the script. But without the serveronly it chokes when it sees the var sqlite3 = require(“sqlite3”);
error-
[2020-04-01 20:36:15.609] [ERROR] Error: Cannot find module ‘/home/pi/MagicMirror/node_modules/sqlite3/lib/binding/electron-v6.0-linux-arm/node_sqlite3.node’The module exists in /home/pi/MagicMirror/node_modules/sqlite3/lib/binding but not in the electron folder.
No idea. I can’t just copy it in - version numbers don’t match.
-
@bobt for your module, you added that as a dependency in package.json, then do an npm install in your module folder.
it should be in
‘/home/pi/MagicMirror/modules/modulename/node_modules/sqlite
-
@sdetweil Thank you Sam for all your help. I created that folder and just copied the module in. I get:
[2020-04-02 07:42:08.104] [ERROR] WARNING! Could not load config file. Starting with default configuration. Error found: Error: Cannot find module ‘/home/pi/MagicMirror/node_modules/sqlite3/lib/binding/electron-v6.0-linux-arm/node_sqlite3.node’
I’m ready to just start over. If I started with a fresh install of MM and wanted to install sqlite how would I go about it? Should I be in the module folder? the MM folder?
Thanks again for your help.
-
@bobt as its used by the module, it should be in the module folder
just copy is always bad
npm install sqlite --save
–save will put it into the package.json in this folder
you should have one(package.json), then u can keep track of your dependencies…
npm init will create one
-
Thanks - and one (hopefully last) question. If I wanted sqlite to be available for a number of modules where would I put it?
