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.html

Which 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).

I attached a file example.

The JulianDay format is a Float64 and is the default format for time/date in SqLite. It is also a pretty universal time format in many scientific systems, especially astronomy, etc.

I have simple (single-file not many methods) open-source javascript (efekt-core.js.st) library I authored for handling basic date/time conversions of JulianDay, UUID, epoch-time, etc.

Thanks for the sample log entries.  Apologies for the delay in getting back to you.  

When I tested, I was also unable to read the data.  This is because several pieces were missing from how we handle reading from a database - including decimal timestamps and Julian dates.  We have just released LogViewPlus v2.5.31 as a BETA release which should resolve these issues:



Note that the jdTime field needs to be explicitly set as the timestamp.


When reading the data, I used the System.Data.SQLite provider for .Net 4.6 x64 build.  No further libraries were used, but note that some characters in the JSON data were not read correctly.  This was a problem I noticed in my SQLite client as well and I suspect is a problem with the JSON type over the ADO.Net provider.  However, I think the data will be helpful as presented.

Hope that helps.  Please let me know if you have any further questions or issues.

Toby