GoGators

Sorry. I should have given a little history. If you look through old lava posts, people have talked about doing an OpenG project where they make SQLite work in LV. The idea was to make a DLL, which would work for PharLap RT controllers (essentailly RT-PXI, and some older FPs and cRIOs). I don't know what happened to that project, but I didn't see anything on OpenG. And yes, since SQLite is ideal for embedded systems, store the database in a single file locally. Since SQLite is connectionless, I would assume it would stay connectionless.

At the request of my sales force and some customers I am going to be writing an article and examples on NI Real-Time targets and Relational Databases (Historical databases seem to be pretty much covered by Citadel). The idea is to generate some starting points, an provide some examples on how-to. After speaking with some peers I have some good ideas, and wanted to bounce them off you Lavanians (do we have a name for LAVA posters?) Before I get too deep I have to ask the most important question. Is this useful. So has anyone out there needed Database support on RT? Ideally there would be information about every topic you could come up with, but the reality is that if no one needs it I am going to use my time on something else. OK assuming someone needs it, there are three scenarios I am pretty sure I am going to talk about. 1) The current NI recommended way to have databases on RT Targets is to make a communication layer between your RT and Host. Then have the host do all the real database operations, and the RT is just passing the information along. I have an example that has the RT send data over TCP to be recorded to a blank .mdb using the Database Connectivity toolkit. Then after some time the RT target requests something like 100 records to use in decision for state machine. Pretty straight forward, and shows that an SQL statement can be passed from RT to host without any translation of data on the host-side (in otherwords the host does not need to know anything about the data, it just works with variants). 2) The RT target makes files in a specific format, then the host retrieves the files periodically and places the data into the database. Some FTP operations, and thats about it. The file format is tricky, so I am still deciding on what to make it. 3) The coolest one by far, make RT targets actually support databases by porting SQLite to Pharlap and VxWorks targets. There has been some talks about it but I didn't see anything definitive on OpenG. Currently trying to get SQLite to build as a DLL in CVI. SO: A) Anybody actually going to use this stuff, or am I wasting time. B) Does the three above meet pretty much all the scenerios you can think of? C) Anyone been working on the SQLite thing lately?