MagicMirror² v2.12.0 is available! For more information about this release, check out this topic.

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?


Log in to reply