1.14.6.108 (Mar 24, 2023)
Includes SQLite 3.40 (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
--> Added "Use Regular Expressions" VI (using 'regexp' extension from https://github.com/nalgeon/sqlean 0.19.3)
https://github.com/nalgeon/sqlean/blob/main/docs/regexp.md
Issue #17: enable URI filenames (https://www.sqlite.org/uri.html#uri_filenames_in_sqlite)
Minor #15,#16
Issue #22 Need to RELEASE Savepoint after ROLLBACK
1.14.5.105 (Nov 28, 2022)
Includes SQLite 3.40 (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
--> Added "Use Regular Expressions" VI (using 're' extension from https://github.com/nalgeon/sqlean 0.17.1)
https://github.com/nalgeon/sqlean/blob/main/docs/re.md
Issue #17: enable URI filenames (https://www.sqlite.org/uri.html#uri_filenames_in_sqlite)
Minor #15,#16
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)
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
1.12.2.91 (Oct 12, 2020)
-- Array of Clusters version of Execute (Issue 6)
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
1.11.2.88 (Jun 30, 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.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
1.9.3.81 (May 11, 2018)
-- Change to LabVIEW 2013
-- Extended Help Documetation
-- Probe improvements
-- Munu links
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
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)
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.
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)
1.4.0.38 (May 19, 2016)
-- Changes required to release on NI Tools Network
-- Added INSERT and SELECT Code Templates (Place Contents)