Using PostgresDB as a DataSource

[the-jan-peter]

I was wondering if and how to use PostgresDB as a datasource.

Any hints would be highly welcomed.

[JamesGibo]

Have you got any exisiting dashboards that use the PostgresDB datasource?
If so please could you download the JSON and share this? I am only interested in the part where the datasource and query are defined as I can use this to compare to the formatting used in grafanalib.

[the-jan-peter]

Aweseomly quick response!

I created a demo dashboard and copied the dashboard json from the dashboard settings:

{ "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "gnetId": null, "graphTooltip": 0, "id": 5, "links": [], "liveNow": false, "panels": [ { "datasource": null, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 0 }, "id": 2, "options": { "showHeader": true }, "pluginVersion": "8.2.6", "targets": [ { "format": "table", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT *\nFROM\n account", "refId": "A", "select": [ [ { "params": [ "value" ], "type": "column" } ] ], "timeColumn": "time", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "title": "account - table", "type": "table" } ], "schemaVersion": 32, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "New dashboard", "uid": "Y8a7onO4z", "version": 2 }

[JamesGibo]

It looks like a new datasource needs to be added for PostgresDB, is this something you would be able to create a PR for?

A new class need to be added to add the PostgresDB target to replicate the following JSON data from your example.
The InfluxDB datasource could be used as a template.
https://github.com/weaveworks/grafanalib/blob/main/grafanalib/influxdb.py

{
      "format": "table",
      "group": [],
      "metricColumn": "none",
      "rawQuery": true,
      "rawSql": "SELECT *\nFROM\n account",
      "refId": "A",
      "select": [
          [
              {
                  "params": [
                      "value"
                  ],
                  "type": "column"
              }
          ]
      ],
      "timeColumn": "time",
      "where": [
          {
              "name": "$__timeFilter",
              "params": [],
              "type": "macro"
          }
      ]
}

[the-jan-peter]

No, I sadly do not fee capable of providing the PR.

I can test the implementation, though