Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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.

share|improve this question
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
add comment

1 Answer

up vote 1 down vote accepted

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

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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