What I want to do:
-
Grafana sends query to my middleware: “select * from peter”.
-
The middleware swaps names for id: “select * from id123” and sends the query to the actual postgres database.
-
The data received by the postgresdb will be sent back to grafana.
How can I accomplish this? Which protocol has to be used?