Hacker News Reader

sounds like a standard BI platform. I'd reach for Google Data Studio, others like PowerBI.

No need to re-invent the wheel with your own DB.

https://www.reddit.com/r/PowerBI/comments/s3o6hi/the_most_in...

ty, not reinventing is the purpose of my post :) I've explored using PowerBI a bit, it doesn't seem to be geared towards extracting the data once it's in PowerBI. I'd want to be able to query the data from other services, for example grafana so that we could set up alerting. There doesn't seem to be a clean way to do this, all I could find was https://learn.microsoft.com/en-us/rest/api/power-bi/datasets...

You could just out an SQL server somewhere and connect it as a datasource to Power BI. If you’d prefer a more standalone and SQL oriented Open Source solution, go ahead an checkout metabase as a BI platform.

However, I’m not aware of any BI platform providing APIs for data manipulation because displaying said data is usually the exclusive responsibility of a BI platform.

BigQuery might be a reasonable hosted DB here - they have proper postgres, etc. but it's a lower level than you may want.

Reply on news.ycombinator.com