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.9k 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.
    • S Offline
      sdetweil @bobt
      last edited by

      @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

      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
        last edited by

        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 Reply Quote 0
        • S Offline
          sdetweil @bobt
          last edited by

          @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
          • PerlchampP Offline
            Perlchamp
            last edited by

            @bobt
            did u find a solution for your problem ?

            S B 2 Replies Last reply Reply Quote 0
            • S Offline
              sdetweil @Perlchamp
              last edited by

              @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

                @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
                • 1 / 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