Hello,
I am not sure how to access/enable using a SqLite data source.
I watched the brief video, and read the documentation area. I then went and read the connection-string required. for the "Data Sources:Add Database Connection:Connection String" section.
However, when I enter in a "Data Source=path-to-db.db3;" with "Table Name:" "aDg_dr" I get an "Invalid Settings" dialog with the message "Unable to establish database connection. Please correct the errors shown.".
The orange-warning-icon tooltip says "Unable to resolve provider for: SQLite".
The System.Data.SQLite packages are designed to be bundled/installed with the .NET APP (LogViewPlus) and not located in the GAC (global assembly cache).
In fact, onerously so. Wherein, powershell "nuget" or various other .NET tools look for and want your development project to install as part of the build. So I can't figure out how to solve the "provider" problem.
🦜Any help would be great, thank you.
P.S., I am looking to use these SqLite features which our log-tools and use of SQLite require/utilize:
-
https://www.sqlite.org/gencol.html-
https://www.sqlite.org/json1.html-
https://www.sqlite.org/expridx.htmlWhich combine to store log records in a SINGLE COLUMN as a single JSON value , where all the other columns are "GENERATED" (via JSON expression implicit triggers) and INDEXES are (JSON1 based expression indexes).
This requires supporting SQLite recent versions after 2019 (2020, 2021 are all ok).