• 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 2.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 Apr 2, 2020, 2:12 PM

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