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?

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.

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.

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

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