Welcome to the Pycom forum Forum
    • \[\[global:header.categories\]\]
    • \[\[global:header.recent\]\]
    • \[\[global:header.tags\]\]
    • \[\[global:header.popular\]\]
    • Login

    Explore Pybytes | Official Documentation | Report a Firmware Bug/Issue | GitHub

    Sending Pysense data to mySQL database

    Scheduled Pinned Locked Moved Expansion Board
    pysensewipymysqldatabasepymysql
    2 Posts 2 Posters 353 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.
    • T Offline
      Tr234__
      last edited by

      Hi,

      I'm trying to send data from the Pysense with WiPy to a mySQL database hosted on an external server. Does anyone have any recommendations on the best way of going about this? I've tried PyMySQL but it seems like it doesn't work on the Pysense.

      Thanks in advance,

      T

      1 Reply Last reply Reply Quote 0
      • C Offline
        CobraKarl
        last edited by

        I’ve experienced similar issues when using MySQL databases.

        What you’re experiencing can most likely be linked to some kind of server problem. That’s what it’s boiling down to most of the time. One of my clients was having a real bad time with his database and I identified the faulty server as being the culprit behind most of the issues.

        Once we switched him up to a cloud server all of the connectivity problems were gone. Also, you could try using a service like Aiven for MySQL.
        With that you can connect appliances to your databases with ease.

        I hope I could help you, and you figure out the problems.

        1 Reply Last reply Reply Quote 1

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • 1 / 1
        • First post
          Last post

        Pycom on Twitter

        Pycom