Database Viewer
Posted 2023-11-23 오후 12:16:06 · 관리자
Dear Customer.
Thank you for using the PowerScene. As you know, you can access all your project data via the data explorer.
System data can be viewed through table view like below.
you can see all your log data in log browser.
We use sqlite engine for our file database backend. You can`t access db file directly for security reason, And You can`t open database file using normal SQLite browser because database is encrypted.
If you use mssql, or maria db as a powerscene database backend, you can see data through their browser. You can convert your Sqlite data to MsSql or Maria db like below.
But you need a Data Access license to use database backend for powerscene.
If you want more than viewing data with data explorer, like access database using, we can add new script api to access database via script.
But we don`t know exactly why you need database schema, if you tell us more information , we can help more.
If you have further question, please let us know,
Thanks
-------------------------------------------------------------
Dear Anygate,
Is it possible to view the project database and the project log database in a generic database browser like https://sqlitebrowser.org/ ? We understand that we can use the viewer in the HMI to see some of the database information, but this is quite limited compared to a full database tool.
Also, we would like to know what tables are stored in the log database and what tables are stored in the project database?
Thank you,
RePurpose Energy