Adding MySQL functionality in LabView

Question

I am new to LabVIEW and trying to make a small project. In LabVIEW from one device, I am measuring some values and then need to store them in database. Initially, I used Excel to store data. But now I need to add MySQL functionality to store data and then later retrieve when need for analyzing.

I look for NI toolkit but it is expensive. I need some free and open source solution for my project. I search over SO and google to find any examples where I can start and make it work, but I couldn't find any. If someone suggest me some resources or having some example code that I can use to achieve my goal. thanks in advance.

Answer 1

Take a look at LabSQL. This works in LabVIEW 2017, allowing connection to a MySQL database without NI's LabVIEW Database Connectivity Toolkit.

Answer 2

I normally use the Database Connectivity Toolkit, but I did confirm I could get this to work in 2017 as well (though connecting to a MSSQL database instead of MySQL).

The only thing that tripped me up at first was not using the Create Connection before Open Connection (because I was used to the aforementioned toolkit). I didn't try anything complicated; I just ran a simple selection query. But it looks like everything should work pretty similarly to the toolkit. As adambro said, if you have a more specific question, maybe we can help with an answer.

Answer 3

I would suggest you could use SQLite. It is a fairly easy toolkit. You can download it via the VI package manager. By dr. James Powell. SQLite is excellent in storing data locally.

Use the SQLite browser from sqlitebrowser.org.

Also a nice way to learn SQL!