@Perlchamp
Thanks everyone for your help. What I was doing was using MMM-MarineWeather By Grena https://github.com/grenagit
as a template to create a MarineTides version. In my simplicity I was loading the tide predictions from NOAA into a table and trying to use sqlite. The problems caused me to do a better job. Now I link to the NOAA website for the info. This allows the module to get the tide info from any (US) location. Works well. I’ll clean it up and try to add it to Git. May need help with that.
Thanks again.

@Perlchamp
Thanks everyone for your help. What I was doing was using MMM-MarineWeather By Grena https://github.com/grenagit
as a template to create a MarineTides version. In my simplicity I was loading the tide predictions from NOAA into a table and trying to use sqlite. The problems caused me to do a better job. Now I link to the NOAA website for the info. This allows the module to get the tide info from any (US) location. Works well. I’ll clean it up and try to add it to Git. May need help with that.
Thanks again.

Thanks - and one (hopefully last) question. If I wanted sqlite to be available for a number of modules where would I put it?

@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.

@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.

If I just send back data without using the sqlite3 it works too.

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);

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??