SQLite Library by JDP Science - Toolkit for LabVIEW Download

SQLite database-in-a-file for LabVIEW

8,297

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

1.13.0.93 (Feb 01, 2021)

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

james-powell was a contributor to this release

1.12.2.91 (Oct 12, 2020)

-- Array of Clusters version of Execute (Issue 6)

james-powell was a contributor to this release

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

james-powell was a contributor to this release

1.11.2.88 (Jun 30, 2020)

james-powell was a contributor to this release

1.10.0.85 (Nov 26, 2018)

-- Backup API (beta; not on pallets)
-- "Memory Used" and "Memory Highwater" properties of Connection (also added to Connection Probe)
-- Get Column as File (copy to file in chunks to handle large BLOBs)
-- SQLite 3.23.0

james-powell was a contributor to this release

1.9.3.81 (May 11, 2018)

-- Change to LabVIEW 2013
-- Extended Help Documetation
-- Probe improvements
-- Munu links

james-powell was a contributor to this release

1.7.3.65 (Jun 23, 2017)

-- Upgrade SQLite to 3.17.0 from 3.10.2.
-- Added "Load Extended Math Functions" method to allow Log(), Sin(), Standard Deviation(), etc. math functions
-- Fix bug in extended error codes and the Step VI

wovalab was a contributor to this release

1.6.3.59 (Oct 14, 2016)

-- Fix bug where Datatype enum was private
-- Fix unconnected output in Last INSERT rowID (also made it a property of Connection)

james-powell was a contributor to this release

1.6.2.58 (May 19, 2016)

-- SQLite 3.10.2 (windows 32-bit and 64-bit) [Note the new JSON1 extension.]
-- Execute SQL made polymorphic with multiple results-returned options
-- Added Path as supported type (where == NULL)
-- "Connection (with Attributes)" extended class, with a (Variant-like) Attributes lookup table stored in the DB file.
-- Option to provide a subclass of SQL Statement to Prepare.
-- "Action" Property Nodes as alternate way of calling Step, Reset, Finalize.

james-powell was a contributor to this release

1.5.0.41 (May 19, 2016)

-- SQLite upgrade to 3.8.7.4 (32bit only)
-- Fixed broken Example-Finder links to examples
-- Added BEGIN and COMMIT (Rollback on error) VIs
-- Changed error codes from 7001+ to 402860+ (reserved codes from NI)

james-powell was a contributor to this release

1.4.0.38 (May 19, 2016)

-- Changes required to release on NI Tools Network
-- Added INSERT and SELECT Code Templates (Place Contents)

james-powell was a contributor to this release

Show all release notes (+10 more releases)

Install with VIPM Download Package

Note: Get VIPM Desktop to install this package into directly into LabVIEW.

Versions

1.13.0.93 (Feb 01, 2021)

1.12.2.91 (Oct 12, 2020)

1.11.3.89 (Jul 08, 2020)

1.11.2.88 (Jun 30, 2020)

1.10.0.85 (Nov 26, 2018)

+ 6 more

Published by

All Contributors

Featured in

Post an Idea Post a Resource

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 year, 10 months ago, 0 , 0
Intro to SQLite in LabVIEW Quick introduction to “SQLite Library” for LabVIEW. Support: https://lavag.org/topic/15857-cr-sqlit… by VIPM Community, 1 year, 10 months ago, 0 , 4

Description

Release Notes

Recent Posts