AdminIvan Schneider (Developer, DbInsights)

My feedback

  1. 9 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
      AdminIvan Schneider (Developer, DbInsights) shared this idea  · 
    • 12 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        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 ?

      • 1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          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