• Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
MagicMirror Forum
  • Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
A New Chapter for MagicMirror: The Community Takes the Lead
Read the statement by Michael Teeuw here.

sqlite - anyone use it?

Scheduled Pinned Locked Moved Unsolved Feature Requests
14 Posts 3 Posters 3.5k Views 3 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    bobt
    last edited by Apr 2, 2020, 3:09 PM

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

    S 1 Reply Last reply Apr 2, 2020, 3:10 PM Reply Quote 0
    • S Offline
      sdetweil @bobt
      last edited by Apr 2, 2020, 3:10 PM

      @bobt i don’t know

      u might be able to put in in the base, and then change your require to include the path to the ~/MagicMirror/node_modules/sqlite version

      Sam

      How to add modules

      learning how to use browser developers window for css changes

      1 Reply Last reply Reply Quote 0
      • P Offline
        Perlchamp
        last edited by May 12, 2020, 10:53 AM

        @bobt
        did u find a solution for your problem ?

        S B 2 Replies Last reply May 12, 2020, 12:16 PM Reply Quote 0
        • S Offline
          sdetweil @Perlchamp
          last edited by May 12, 2020, 12:16 PM

          @Perlchamp you should create a package.json for the module
          by doing npm init in the module folder, and answering the setup questins.
          the questions only add text to the package.json, nothing else

          and then

          then install your dependencies

          npm install --save sqlite3

          –save means add this to the package.json dependencies section

          when u are done, you can send the package.json to another person,
          and they can run npm install in the module folder and get the same
          supporting code installed for this module

          and if you asked for a SPECIFIC version of some library,
          that would be recorded in the package.json too, so the other user would get
          the same level of the dependency

          Sam

          How to add modules

          learning how to use browser developers window for css changes

          1 Reply Last reply Reply Quote 0
          • B Offline
            bobt @Perlchamp
            last edited by May 18, 2020, 11:56 AM

            @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.
            20200413_132310_resized.jpg

            1 Reply Last reply Reply Quote 1
            • 1
            • 2
            • 2 / 2
            • First post
              Last post
            Enjoying MagicMirror? Please consider a donation!
            MagicMirror created by Michael Teeuw.
            Forum managed by Sam, technical setup by Karsten.
            This forum is using NodeBB as its core | Contributors
            Contact | Privacy Policy