Hi all, given that Grafana is a great piece of software, I was wondering why traditional RDBMS are not (yet?) fully supported.
I am talking about PostgreSQL/MySQL . In my case I have an API (a proof-of-concept) that write data right into PostgreSQL and then I have written a trigger function that insert data to an InflusDB database. So that I can graph data with graphana…
Would it be easy to write a PostgreSQL datasource? and why PostgreSQL cannot be used today with grafana?
We just added the alpha version of the MySQL data source to Grafana and Postgres is next on the list.
The reason why they haven’t been added earlier is that they are not time series databases like InfluxDB or Graphite. So they are more a complement to the main databases that are supported by Grafana. We are not expecting anyone to use a relational db as their main db for metrics.
Not saying the timescale are wrong at all. That is a time series db built on top of Postgres and that is not the same as using postgres for metrics.
We agree with what you are saying which is why we are adding data sources for relational dbs. Just explaining why it has been a lower priority than supporting all the time series dbs (graphite, influxdb, elasticsearch, prometheus, OpenTSDB, KairosDB and lots more).
Please, is there any timeline on when the Postgres is going to be supported as a datasource plugin?
Are there any efforts or branches where this is being worked on? Just wondering if I could contribute or just quickly hackup Postgres Datasource myself based on our MySQL datasource.
@ales I just finished some more work on the MySQL data source and Postgres is next on the list. But I have another feature to finish first (dashboard folders) before going on to Postgres so it will be a few weeks before I start on it.
@daniellee what would be involved in writing a PostgreSQL data source?
Will your work-in-progress be visible somewhere, can I be a beta tester, how can I contribute, etc ?
@hkrosing please excuse the late reply - I’ve been on vacation. The Postgres data source will be very similar to the MySQL one so it should go relatively quickly. We will probably follow the same procedure as with the MySQL db and include it in the 5.0 release as an alpha version to get feedback.
@majdby you can use Postgres to store Grafana data (dashboards, users etc.) but there has never been Postgres data source (a data source means that the data can be used in dashboards and graphs). Installing an older version won’t help.
We are working on another feature (dashboard folders) and when that is done then the Postgres data source is next on my list. The 5.0 release beta is planned to be released at the end of September.
Just adding that this is a huge feature for me, and is currently the only thing keeping me from choosing Grafana. Would love to see this added soon.
Is there any way to add third-party plugins to hosted Grafana? I found a third-party postgres source, but it looks like the only way to add it is to add it manually to some folder.
@iechoic we only allow published plugins on Hosted Grafana. I don’t think it would be a good idea to allow installing unverified plugins to our hosted platforms. Firstly, it could potentially be a huge security problem. Secondly, it would be very difficult for us to support unverified plugins. Some users would expect support if the unverified plugins did not work or corrupted data.