Communication between LabVIEW for myRIO and a mySQL remote DB

[sbigeard]

Hello,

As part of a project, we would like to communicate between LabVIEW installed on an NI myRIO-1900 embedded target and a mySQL database installed on a remote server. Is it possible and to what extent?

Although this is not very sensible given the limited resources of myRIO, we could also consider installing and activating a mySQL database server on the myRIO embedded map provided that it can be accessed from a (or more) remote mySQL client (s). Is it possible and to what extent?

I thank you for your feedback,

[Tepig]

In myrio, Linux is running so, I guess general operation can be performed like this.

Connect to a MySQL database remotely

You can run shell commands on the device.

Running Shell Commands and Custom Applications in Linux Real-Time OS from LabVIEW

[nanocyte]

You could use TCP to connect to the mySQL database. Something like this?

https://forums.ni.com/t5/Example-Program-Drafts/Native-LabVIEW-TCP-IP-Connector-for-mySQL-Database/t...

[sbigeard]

Thanks for your proposition.
I will try soon and I will keep you informed of my tests.

[sbigeard]

Thank you very much "nanocyte" for this link.
I will read this with great attention.