Database in CompactRIO

[gomezramones]

Hi, I'm doing a project which is made a database in a CompactRIO to save some data like alarms, analogic signals that receives the device. It was a project where started 1 year ago and the person who was responsible about the project achieved some things using PostgreSQL in a CompactRIO 9030, however the result wasn't excellent or what was expected because it was very volatile.

I got two options to do this project: SQLite and Database Toolkit Connectivity. But I don't which I need to pick to achieve the best result.

[JensG69]

The database connectivity toolkit is not an option. It uses Windows calls (ADO) and will not run on a cRIO running NI Linux Real-Time. SQlite might be a good option. You just need the SQlite-DLL for it to run, so you have to compile SQlite for this specific target, perhaps you can use an already existing DLL for Linux & x86-architecture.

Regards, Jens

[gomezramones]

If I have a Library in LabVIEW that use SQLite, which was created by LVS-Tools, I could use that library in CompactRIO and run it in NI Linux  Real-Time?

[gomezramones]

I'll attached a picture about LVS-Tools Library

[JensG69]

I'm not familiar with this library. If it uses the sqlite3.dll directly without any wrapper, it could be that this library will work on an cRIO. BUT: You still have to use a sqlite-Linux-x86 SO library.

Jens

[gomezramones]

Where can I find sqlite-Linux-x86 SO library? And other thing if I create a .dll for my database, how do I use that format in CompactRIO? Because .dll is not compatible in Linux so I would have to install a emulator in CompactRIO to do that and i don't if it is possible

[daharden]

Did you ever get to work? did you need to install software on the RIO to get this library to work?