I have a website that I've built and it uses a SQL DB.

I want to be able to view that data, nicely graphed but with the relations made, so that I can keep track of trends over time.

For example I don't just want to be able to look at the trend of users joining over time, I want to know which users did the most of an action, and what they did. This would involve joining several tables.

So, can anyone suggest any tools to assist me in doing this?

Ideally the product/service would import the DB (or access it), I'd specify which tables to join and on which attributes and it would produce the graphs.

I don't want to go the custom route and build the graphs myself. I'd like something I could use there or in another similar situation.

  • 2
    By "SQL db", do you mean Microsoft SQL Server, or something else like MySQL? – DisgruntledGoat Feb 1 '12 at 17:08
  • You should also specify your desktop OS, if locally-installed applications are up for consideration. – Su' Feb 1 '12 at 17:18
  • I didn't think that the DB type would make a difference as with databases you can either export them or use ODBC to get access. It's actually mysql if it helps. – user24091 Feb 2 '12 at 12:02
  • I didn't mention the desktop type because I didn't think it was relevant or necessary. I'm willing to try Windows, Mac, Linux, cloud or anything else I can get my hands on :) – user24091 Feb 2 '12 at 12:03

DBVisualizer is a desktop application that has charting functions, is cross-platform, and runs against a wide variety of db engines.

  • DBVisualizer seems to do the job fairly well so far. Not too expensive too, which is a bonus. Thanks! – user24091 Feb 2 '12 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.