sql charting support?

[expired user #8011]'s profile image [expired user #8011] posted 10 years ago in General Permalink
Hi,

I develop software that allows creating live charts and dashboards for sql databases:
http://www.sqldashboards.com/

A command line version and basic parts are all free, one thing we are considering doing is integrating with HeidiSQL, ie. some kind of plugin that allows transferring a chart query across into a live dashboard. You can see similar functionality for a different IDE here if you click on the video link: http://www.timestored.com/qstudio

I'm a big HeidiSQL fan and am the one pushing in work for the plugin to be created. My boss has said to find out if any other HeidiSQL users would be interested. Please contact me back direct if you are. It will really help make the case.

Thanks Ansgar for a great piece of software.
ansgar's profile image ansgar posted 10 years ago Permalink
Is the free Version capable oft displaying a chart?
[expired user #8011]'s profile image [expired user #8011] posted 10 years ago Permalink
sqlDashboards allow creating dashboards that contain multiple sql charts that update in real time. Every part of creating and configuring a chart is free however you can't save/open dashboards to file.

sqlChart allows generating charts from sql at the command line, the free version is fully functional but has a small watermark (<15% image size).

Ansgar, as a thanks for HeidiSQL I've ok'ed it with my boss to offer you a a license free.
ansgar's profile image ansgar posted 10 years ago Permalink
OK, thanks so far.

So you can create charts per sqlChart and then open it per sqlDashboard? You say the free version cannot open dashboards, so how to open these charts? What format do they have?
[expired user #8011]'s profile image [expired user #8011] posted 10 years ago Permalink
>> So you can create charts per sqlChart and then open it per sqlDashboard?
No, sqlChart is only a command line tool for generating a static .png image of a single chart. It's a separate tool that came from user requests to allow scripting for sending email reports etc.

>> You say the free version cannot open dashboards, so how to open these charts? What format do they have?
With the free version you would have to recreate your dashboard each time you close/reopen the program. While you have it open, the charts query the database to stay updated and you can still export .png for each chart.

Dashboards are stored as proprietary XML to a .das file,
e.g.
<dashboard>
<chart sql="select * from table1" format="bar chart" />
<chart sql="select avg(salary) from employees" format="time series chart" />
</dashboard>

If you go to 8 minutes 20 in this video http://www.sqldashboards.com/help/video-tutorial/kdb-database-live-charting you'll see saving/opening a .das file
[expired user #8011]'s profile image [expired user #8011] posted 10 years ago Permalink
For example, for a website like heidiSQL you may like to have a dashboard showing:
- downloads in last hour
- downloads in last 7 days
- forum posts in last hour
- mysql database server memory use / CPU use over time.

A dashboard allows watching sql data in real time, while sqlChart allows generating images for longer term use or emailing etc.


In terms of a plugin to HeidiSQL I think it would be good to allow:
1. Charting for any SQL queries sent.
2. Ability to export queries to a dashboard.


Please login to leave a reply, or register at first.