MySQL

[michalt38]

Hello,
how can I send commands to a MySQL database via WiPy?

[rskoniec]

@michalt38 Here (click me) is a good example about what @livius said.

[livius]

@michalt38 said in MySQL:

connect by wifi
https://docs.pycom.io/pycom_esp32/library/network.WLAN.html

and then create socket and connect to service listen on some port
https://docs.pycom.io/pycom_esp32/library/usocket.html

[michalt38]

@livius
Ok, but how to connect to this service?

[livius]

@michalt38 said in MySQL:

Do you have an example code that runs MySQL in a way you described?

look in google about creating service
I am Delphi developer and for me it is easy there - but Delphi is not free software
and beacuse of this i say google for the answer.
If you have Delphi i can tell you more :)

[michalt38]

@livius
Do you have an example code that runs MySQL in a way you described?

[livius]

@michalt38
create service/webservice on computer/server and inside it connect to mysql
then connect to that service and send data from wipy by eg wifi
i do this in that way to connect to Firebird sql database