igorbounov

Why RT or ARM targets? No, it's all quite simple. I've installed VIPM, it installed this drjdpowell SQLite Library, it seems that all work marvelous! Thanks again for this great library! I've tested two sqlite examples - they work without problem! The only inconvenience - the search in Example tab cannot find "sqlite", I've found examples in a directory search of Examples window.

In Fedora (and hence, in RedHat and CentOS, too) sqlite is located in: /usr/lib64/libsqlite3.so.0 /usr/lib/libsqlite3.so.0 Those are stable links to actual libraries for 64- and 32-bit library builds.

I've got VIPM from JKI, there are also installation instructions available, but there is not said how this VIPM could be run in an already existing LV 2018. But all this VIPM things are useless if SQLite Addon is unusable under Linux. sqlite3.so is available in any Linux distribution (and in any Android, almost in every SmartTV, smart-refrigerator...).

drjdpowell, it appeared so that I've got an installation of Labview 2018 (Full development system) for Linux (my main OS). The distribution, althogh full development sysytem, has no VIPM. Moreover, the most recent VIPM is VIPM 2017 which (for Linux) is shipped with Labview 2015 SP1 RTE and it doesn't see installed Labview 2018. And - the final blow - I see that your SQLite Add-on for Labview is available only for Windows! For LV 2017 maximum! Is there any workaround?

drjdpowell, is there something special in the way that SQLite for Labview uses for storing Blobs? I can not recover back the binary data stored in a blob: Here the wire to Unflatten from String comes from a "Sqlite EXEC SQL" VI, the data on this wire as shown in a String indicator look like a JPEG data should look but "LabVIEW: Unflatten or byte stream read operation failed due to corrupt, unexpected, or truncated data." So something is wrong with binary string from Sqlite Query (may be it is not a binary string?).

Yes, it was a mistery to me when I've seen by means of probe only one byte of data until I have thoroughly read the documentation. And also it appeared that "little-endian" is not a default byte order for reading binary files. I was also puzzled when "Bind Timestamp" for time field appeared to produce a 16-byte Blob that DB Browser for SQlite sees as pure binary data. This item was discussed a fiew pages ago so "Bind Timestamp (Unix)" looks like a more conveniant format for selecting, sorting and comparing. When I've built a test executable application for my LabView program, application builder produced a dll for SQlite support - should it be shipped along with the exe-applications?

Yes, finally it works this way: It is so simple! Thanks!

No, it gives only one-byte Blob, but this is the correct byte! So this is the way in the right direction! So I need extracting remaining bytes.

There is almost nothing to provide as an example, it seems that I simply don't know how to prepare data for Bind Blob: And here is the contents of resulted Blob as shown by DB Browser for SQlite: Only five bytes :-( .. from a jpeg image (about 80 kbytes). And here is another way - from jpeg to blob: And here is its blob contents (4899028 bytes from the same 72821-bytes image). So it looks like I do something (or may be everything) wrong. Here is the way I try to flatten the data from wav-file: There is nothing to be proud of because I get this blob contents from a 1982508-bytes of wav-file: I can not understand why I should represent the binary data (some portion of memory - if it were a C-program) as a text.

Can you give me an example (to get the idea)?

I've failed to convert binary data to string suitable for insert in a database as BLOB (via Bind Blob property). May be I'm too new to LabView yet. So would anybody give me a hint how it can be done? Binary data are jpeg picture (from Read JPEG File.vi) and waveform data (from Sound File Read.vi). I've used the "Flatten to String" function and "Variant to Flattened String" function. And also have tried a combination of "Read From Binary File" + "Variant to Flattened String" functions. In any case the blob data seen by DB Browser for Sqlite seem to be essentially different size. And there is no RIFF tag in case of JPEG file blob. I know that using Blobs for storing data is not a good idea but I need this kind of experience.