IO&G Users: Internal SQLite Database Improvement
Ultimately we need to have free access to the internal database. We also do not want to risk java.sql.SQLException: Connection is locked. Datasource only allows one connection, due to expensive reads or writes... It would be nice for Ignition to create a copy of the internal SQLite database with an interface to query it as desired. Additionally, there could also be a merge or restore internal for writing back changes to the copied .idb file. It could be an Ignition API that reads or writes to a copy of the internal database. The point is that there is information in the internal db that we desire access to without degrading gateway performance.
Kathy A. commented
Ignition 8 will fix many of these issues.