About This File
Introductory video now available on YouTube: Intro to SQLite in LabVIEW
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.
See the original conversation on this here.
Hosted on the NI LabVIEW Tools Network.
JDP Science Tools group on NI.com.
***Requires VIPM 2017 or later for install.***
What's New in Version 1.11.3 See changelog
-- SQLite 3.31.3 , including:
-- Generated Columns https://www.sqlite.org/gencol.html
-- "Execute SQL" now has a "Parameters" input (accept one parameter, or many in a cluster)
-- Added Timestamp options, including Julian Day and Local Time Offset text form (RFC-3339)
-- bug fix to allow arrays of enums
-- 1.11.3 version fixes a critical issue in "Commit (Rollback on Error).vi" present in 1.11.2
This Package depends on these other packages: JDP Science Common Utilities >= 126.96.36.199