Bermos commented on issue #8350: URL: https://github.com/apache/incubator-devlake/issues/8350#issuecomment-2772731689
Hey @mstrangfeld, we are also working with a Postgres DB and would like to make this officially supported. From our experience the ingestion part works well, the biggest problem are the Grafana dashboards. I've done some research and stumbled upon this project from Grafana themselves: https://grafana.github.io/grafana-foundation-sdk/next+cog-v0.0.x/go/How-To/custom-query-type/ . It basically allows for defining dashboards with their panels and queries to be defined in code (Go is supported) and then "rendered" as JSON. This would allow us to in a first step to render out both MySQL and Postgres Queries in their respective dashboards. Other things that would make it more practical to use in my opinion: - Use something like https://github.com/Masterminds/squirrel or https://github.com/doug-martin/goqu/blob/master/docs/dialect.md to build for both dialects - Validate queries by running them against a DB with known data and match results against expected results - Instead of reloading the dashboard JSONs form disk in Grafana, use the Grafana API to let DevLake insert/update the dashboards Another, smaller issue is the helm chart which needed quiet some fiddling to get working properly with a Postgres DB but I'd say that has a lower priority. Feel free to contact me if you'd like to discuss any of those inputs. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
