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.
@livius
Hello,
Thank you very much for your quick response, as am new to server and pycom, it would be great help if you could share the code from fipy side and server side with step by step procedure.
Thank You
@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 ....
@prakash
If your question is how to create webpage and access data in mysql
then this is not proper forum for such info.
but - look at this detailed tutorial with PHP technology
https://www.ibm.com/developerworks/linux/tutorials/l-php/index.html
You can use any other method like .net, java...