Sign In

SQLite Library by JDP Science - Toolkit for LabVIEW Download

SQLite database-in-a-file for LabVIEW

* 3 ↓853
 logo
Version1.11.3.89
ReleasedJul 08, 2020
Publisher JDP Science
LicenseBSD
LabVIEW VersionLabVIEW>=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.

Release Notes

1.11.3.89 (Jul 08, 2020)

-- 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 included bugfix in Commit (Rollback on error) vi

Install

Note, you must have the VIPM Desktop app installed for this button to work.

Versions
Featured in

  Post an Idea   Post a Resource

Recent 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, 1 month ago, 0 , 0
resource
Intro to SQLite in LabVIEW
Quick introduction to “SQLite Library” for LabVIEW. Support: https://lavag.org/topic/15857-cr-sqlit…

by VIPM Community, 1 month ago, 0 , 3