SQL Databases and Linux

[ratem]

Hi,

I have searched through the list and could see that the few messages database connection under Linux got no answers!

So, I would like to know if there is any possibility of connecting LV 7.1 or 8, under Linux, to a SQL Database.
It would be a good thing to have this kind of solution, since there are very fast and lightweight databases under Linux, like Firebird and MySQL.
Also, we have a project where the LV application will run under Linux, and treated data will be persisted in a Oracle database, under AIX.

Thanks in advance,

Rogerio

[tst]

Try looking in the LAVA forums (which have been down for the last couple of days, I'm not sure whether they're up again). I saw there recently someone who tried to talk to a DB using the shared library (I believe it was windows with a DLL in that case) of SQLite. It will probably be applicable to Linux as well.

[rolfk]

---

@ratem wrote:
Hi,

I have searched through the list and could see that the few messages database connection under Linux got no answers!

So, I would like to know if there is any possibility of connecting LV 7.1 or 8, under Linux, to a SQL Database.
It would be a good thing to have this kind of solution, since there are very fast and lightweight databases under Linux, like Firebird and MySQL.
Also, we have a project where the LV application will run under Linux, and treated data will be persisted in a Oracle database, under AIX.

Thanks in advance,

Rogerio

---

It really depends if you want to do programming on your own or rather want to spend some money for a Toolkit. We at CIT Engineering use internally two different Toolkits developed inhouse for accessing databases through ODBC.
One of them is somewhat elaborate with support for binary datatypes and written in such a way that it can be linked to unixodbc without much problems. The only issue with this is that distribution of shared libraries that link to other libraries on Linux is not something as straightforward as on Windows. I have only done some prelimenary testing on Linux until now since there hasn't been an immediate need for this but it is something we are looking into periodically.

You can read about this Toolkit at http://www.citengineering.com/pagesEN/products/databases.aspx and if you are interested I can try to see what could be done in this case to fully support Linux.

Rolf Kalbermatter

[ratem]

Thanks for the hints, I will check both.
I also thought about a system based solution, where LV stores data in files normally, and I use an external programs to load into a database. Of course, this kind of solution only applies to situations where it isn´t necessary to have data in the database on the fly.

[ratem]

HI, FYI we managed to connect LV to PostGreSQL and MySQL indirectly, through command line arguments. Althought that's not an elegant solution, in comparison to drivers, it worked fine for us (very fast).