SQLite Library by JDP Science - Toolkit for LabVIEW Download
SQLite database-in-a-file for LabVIEW

Version | 1.13.0.93 |
Released | Feb 01, 2021 |
Publisher | JDP Science |
License | BSD |
LabVIEW Version | LabVIEW>=13.0 |
Operating System | Windows, Mac, and Linux |
Project links | Homepage |
Description
SQLite3 is a very light-weight, server-less, database-in-a-file library. See www.SQLite.org. This package is a wrapper of the SQLite3 C library and follows it closely.
There are basically two use modes: (1) calling "Execute SQL" on a Connection to run SQL scripts (and optionally return 2D arrays of strings from an SQL statement that returns results); and (2) "Preparing" a single SQL statement and executing it step-by-step explicitly. The advantage of the later is the ability to "Bind" parameters to the statement, and get the column data back in the desired datatype. The "Bind" and "Get Column" VIs are set as properties of the "SQL Statement" object, for convenience in working with large numbers of them.
Note: it may be necessary that VI Package Manager be "Run as administrator" in order to install this package.
Release Notes
Includes SQLite 3.34.1 (See https://sqlite.org/changes.html)
Issue #10: Attribute parallel access bug
Issue #11: Parameters Input wrongly accepting an Array of Clusters
Issue #13: Optional Static bind of Blob/Text
Note, you must have the VIPM Desktop app to install this package into LabVIEW.
VersionsRecent Posts
User Group for JDP Science Tools at NI.com
A User Group for questions and discussions about packages by JDP Science, such as SQLite Library, J… by James Powell, 6 months ago, 0 |
|
Intro to SQLite in LabVIEW
Quick introduction to “SQLite Library” for LabVIEW. Support: https://lavag.org/topic/15857-cr-sqlit… by VIPM Community, 6 months ago, 0 |
|