9 votesAdminIvan Schneider (Developer, DbInsights) shared this idea ·
Thank you for your suggestion.
There is currently no way to parameterize reports and their associated charts but this is a need I previously encountered and I'm willing to implement it in DbInsights. Still trying to figure out the right way to do it though.
Am I right in understanding that you have a database containing various types of records linked to say a users tables through a user_id column and you would like to define a report with various charts parameterized by the value a specific user_id ?
How do you imagine you would give access to those reports to your users ?
To which other players in this market are you referring specifically ?
Point taken for the columns, I'll see what I can do.
The graph is on the same page, so if you don't see it, this might be a browser issue. The graph is rendered with SVG so you need an SVG-capable browser.
I tested on Chrome, Safari and Firefox and it displayed fine. Which version of which browser are you using ?
I'll look into the exception for the report creation and get back to you by email.
It's fixed :)
Or at least modified.
I finally ended up using the Dracula Graph library (http://www.graphdracula.net/). There's no more the problem of too large a graph or limited size of the image (I adapt the height of the graph depending on the number of tables).
I can now see the graph of one of my schemas with 65 tables, however it's not that usable. I guess the node placement generated by this lib is not as good as what graphviz can do (although I never saw the graphviz version of that schema).
Also I didn't put back the columns on this version of the graph. I don't know if that's really necessary since they're listed below (or maybe I could display them on mouseover ?).
Overall with a bit of tuning I think this version might be good.
Let me know what you think about it guys.
The problem is DbInsights is currently hosted on Heroku, which to my knowledge doesn't allow the use of Graphviz. So I used the Google Chart support for Graphviz (http://code.google.com/apis/chart/image/docs/gallery/graphviz.html) which as stated is experimental. There is a limit on the size of the image generated (http://code.google.com/apis/chart/image/docs/chart_params.html#gcharts_chs) and on the complexity of the graph as well (limited to 2K with a GET request and 16K with a POST request).
The only other option I found is Canviz (http://code.google.com/p/canviz/) to render the dot graph directly in the browser, I'm going to give it a try and see if it can replace Google Chart in DbInsights.