SQLite Library by JDP Science - Toolkit for LabVIEW Download

SQLite database-in-a-file for LabVIEW

11,150

Version	1.14.3.100
Released	Jul 06, 2022
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.

Note: it may be necessary that VI Package Manager be "Run as administrator" in order to install this package.

Release Notes

1.14.3.100 (Jul 06, 2022)

Includes SQLite 3.39.0 (See https://sqlite.org/changes.html)
--> Added the -> and ->> operators for easier processing of JSON
--> Added built-in SQL math functions() WARNING, these override the same-named Extended Math Functions of this library and changes the meaning of Log() to Log10() rather than natural Log(); use Ln() instead

Issue #17: enable URI filenames (https://www.sqlite.org/uri.html#uri_filenames_in_sqlite)
Minor #15,#16

Issue #19: add "Use Regular Expressions" VI (using 're' extension from https://github.com/nalgeon/sqlean)

james-powell was a contributor to this release

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 and james-powell were contributors 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 (+11 more releases)

Download Package

Versions

1.14.3.100 (Jul 06, 2022)

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)

+ 7 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, 2 years, 2 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, 2 years, 3 months ago, 0 , 4

Description

Release Notes

Recent Posts