Navigation

    Welcome to the Pycom forum

    Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    1. Home
    2. Tags
    3. database
    Log in to post

    • shanefowler25

      SQL Database with GPY board
      Discussion • gpy getting started database sql get • • shanefowler25  

      3
      0
      Votes
      3
      Posts
      334
      Views

      shanefowler25

      Hi @jcaron, Thank you for answering, so I reviewed that other forum as well before and I am still a bit confused. I understand creating a server side script in python, php, etc. to execute the SQL queries, however, I’m lost at how to return the results over HTTP. I see the other forum talks about sending data to a MQTT broker, is that something I would have to do? Send the query results from the database to the broker and then subscribe to the MQTT?
    • T

      Sending Pysense data to mySQL database
      Expansion Board • wipy pysense database mysql pymysql • • Tr234__  

      2
      0
      Votes
      2
      Posts
      340
      Views

      C

      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.
    • N

      Using WiPy to send AC current consumption data through wireless current sensor to AWS Influx DB
      Discussion • wipy 3.0 aws database xbee • • noboz32  

      1
      0
      Votes
      1
      Posts
      357
      Views

      No one has replied

    • H

      Read the Sensor data through AWS cloud using WIPY
      Discussion • sensor wipy i2c database cloud • • harper75  

      4
      0
      Votes
      4
      Posts
      733
      Views

      C

      Hello. Recently I've been reading blog - pro4people.com and I have to admin that AWS cloud services got my attention. What ERP system would you recommend if we want to use amazon website services? Is it possible to use SAP on this network? Let me know please, since we are completely new to this subject.
    • S

      Mongo db with Pycom GPy
      Discussion • gpy database • • sprasad  

      7
      0
      Votes
      7
      Posts
      1091
      Views

      S

      @TravisT @jcaron Thank you guys! That is exactly what we decided to do. Connect to a webservice on the internet with wifi and make that communicate with the database.
    • F

      ImportError: no module named 'MySQLdb'
      LoPy • lopy pymakr database mysql • • Fajriansyah  

      6
      0
      Votes
      6
      Posts
      1647
      Views

      livius

      @fajriansyah I do not know if some "minimal" client exists for micropython. But is it required? Better run some listen socket on your server. And then your Lopy will send messages to this socket and it connect to jour database and store there data. It can be e.g. windows service apllication, webserver application e.g. on IIS, Apache + php ....
    • 1 / 1