Something like this would be super nice for UMH! �...
# general
d
Something like this would be super nice for UMH! 🙂 (to query the database better from grafana) https://www.factry.io/blog/factry-historian-grafana-data-source-plugin/
@Jermuk coming back on the post i made last week: https://www.factry.io/blog/historian-v7.0-release/ some of the features highlighted here would be very nice in UMH. (they have some vids available now) as UMH is also working towards data modelling,... i think this is relevant
@Jasperlg you know this too, any thoughts on this?
j
I haven't seen the update before. Why do you need asset modeling in the historian? And the metadata looks nice, but where do you see the metadata? In Grafana with their plugin? Or do you have to login in their dashboard to find the metadata?
j
Yeah, I really love their Grafana datasource plugin. Its really nice! Right now the focus of us is more towards power users (who prefer to use SQL) as they are currently the main UMH users, but I really hope we can go fix our datasource and make it as usable as theirs. @bhashkar.umh here is a good example of what we should do in the future with our Grafana datasource 🙂
The metadata part is what we are working on in a couple of weeks, and we are preparing the mockups etc. at the moment 🙂 you will be able to add them using the management console in the protocol converter section 🙂
d
Great, thanks! 😄 trying to guide you in the direction I would like UMH to go Costumer feedback! 😄
d
what you could do which would be a really nice feature is to leverage for example redis in queries and cache the queries so if you have viewed for example 12h of a value in any dashboard and in another dashboard you are using the same value but last 2h you read if from redis instead of postgres and for each update you query only the new values since the last update instead of the complete 2h or 24h.. this would reduce the stress on the database significantly.
7 Views