Browsing database.db

Not sure if anyone has asked this or have had the need but would it be possible to view the database.db in PowerBI or other SQLite browser tools?

I know PSU does have SQL support in version 3. link but I’m not sure if this is the only solution.

It would be nice to be able to view and track jobs / users / and other information about the PSU instance.

2 Likes

You can use LiteDB Studio to view the database but won’t really be able to use something like PowerBI with it GitHub - mbdavid/LiteDB.Studio: A GUI tool for viewing and editing documents for LiteDB v5

@adam - Is my assumption correct that this will be an opportunity to use PowerBI if we use a dedicated sql server with V3?

Correct. You’ll be able to hook up whatever tools you want to the shared PSU database.

1 Like