AdminIvan Schneider (Developer, DbInsights)

My feedback

  1. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
    AdminIvan Schneider (Developer, DbInsights) shared this idea  · 
  2. 12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
    AdminIvan Schneider (Developer, DbInsights) commented  · 

    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 ?

  3. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
    AdminIvan Schneider (Developer, DbInsights) commented  · 

    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.

    AdminIvan Schneider (Developer, DbInsights) commented  · 

    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.

    AdminIvan Schneider (Developer, DbInsights) commented  · 

    Agreed.
    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.

Feedback and Knowledge Base