4 ms·
I want a simple reporting tool / dashboard. Every week I run a couple SQL queries against my database and copy the results to a spreadsheet for graphing. I fee
by jakobegger 10y ago
I want a simple reporting tool / dashboard.
Every week I run a couple SQL queries against my database and copy the results to a spreadsheet for graphing. I feel that there should be an easier / more automatic way to do that.
Existing software that I have looked at sucks because of one of the following reasons:
- it is ridiculously expensive
- it is complex to set up and using it would be harder than my current setup
- it is cloud based and would require sending credentials to my database on a third party server
- hanniabu 10y agoWhat type of graphs do you create, how many data points, and is it the same graph you're making every time?
- jakobegger 10y agoI mostly look at weekly revenue and trial downloads vs. sales, so I have at most a few hundred data points. I make bar charts mostly. (I don't think line charts are good for data that fluctuates a lot). It's always the same graph.
- codegeek 10y agoHave you seen metabase ? http://www.metabase.com http://www.metabase.com
- jakobegger 10y agoThis looks interesting. I'll check it out. Thanks!
- ivanceras 10y agoDid you get what you were looking for in metabase. If not, I may have to tailor my base open-source data management project[0] to your need https://github.com/ivanceras/curtain https://github.com/ivanceras/curtain
- stevekemp 10y agoRedash? Allows you to produce graphs/charts of your own data, by writing SQL queries. Self-hosted too.