Has anybody worked with Metabase (https://www.metabase.com/) on top the PostgreSQL / TimescaleDB system? It supposed to be good for creating simple dashboards. Plus it has a selfhosted free version. Just before I dive into it... anyone has some experience?

I’ve been using flowfuses dashboard nodes in NodeRED for this.

what i am looking for is a way to create some easy dashboard where i can have some button that performs actions like pushing api call and sending data to mqtt.. This way i could interact with the erp-system without messing with the database(which i cannot acces through garafana due to odd database-type).. i will try flowfuse as soon as i get the time.. node-red works fine for 1 user but when you have inputs all viewer have the same input..

Flowfuse does a really good job of taking NodeRED and making it scalable for the enterprise. RBAC, HA, instance management, version control. They have cloud, on-prem, and custom. On-prem flowfuse is free for up to 5 instances, 5 accounts, and 5 devices. Docker-based too. I'll have to see if they have a helm chart. https://github.com/FlowFuse/helm

Yes. I have meaning to test it for a long time but lack of time has made it low priority. How is it for end users? Can you have 50+ different viewers on the oss version? Can they view the same dashboard but have different inputs?

For the open source version (On-prem starter) it is limited to 5, but with 50 users (or 5) you can have all of them view and input the same dashboard (with each input being different/associated with that user). They call it multi-user dashboard

I did not know streambase so far, but it looks like a good tool for the process engineer to analyse his production data.

I think we could do it in grafana with user input but the mqtt-support is still not so good. There is an option to use http nodes to push data but when i tried it to node-red i got problems with reverse proxy.. Maybe i will have a look at the source code for the mqtt-datasource and see if it is possible to improve(within a reasonable amount of time).. There is a also a way around the multiuser for node-red. you can quite easily build a login with different users and alter the functionallity on buttons depending on the user.. i have an example somewhere with a user login. perhaps a quicker way atm is to use that while looking for an alternative..

I'll see what I can do. I gotta update my UMH instance first. Been wanting to do updates via gitops, but I think I'm just adding more work for myself.

updating is at the moment not possible via gitops, as it requires the UI (to guide the user through some manual steps, or to automatically do database migrations ,etc.) but you can deploy all protocol converters and network connection and custom data flow component sthrough gitops by managing the mgmtcompanion-config configmap in kubernetes!

Oh interesting!