I tried to configure openHistorian with a SQLite database. Here: https://github.com/GridProtectionAlliance/openPDC/wiki/Getting-Data-From-the-openHistorian
Choose your database type:
I chose my database SQLite that i configure to openPDC, with my microPMU.
After that: Copy the openHistorian database and rename it to openPDC
But is also my database of openPDC(file pathname in openPDC). I only have to copy this datebase and rename it to know that is the database(with virtual device) to view historical data.
Other problem is:
I use a SQLite datebase and when i try to change this items i have an error. It is the same when i chage the value and not the name of column
Find the CustomInputAdapter table.
Find the custom input adapter created in step 6.
Change the TypeName to: openHistorian.Adapters.LocalInputAdapter
Change the AssemblyName to: openHistorian.Adapters.dll
It is possible to view historical data from a SQLite database? I use DB Browser for SQLite to edit database.