sqlDashboards Blog

sqlDashboards adds Step Plot Visualization

Our standard time-series graph interpolates between points. When the data you are displaying is price points, it’s not really valid to always interpolate. If the price was 0.40 at 2pm then 0.46 at 3pm, that does not mean it could be interpreted as 0.43 at 2.30pm. Amazingly till now, sqlDashboards had no sensible way to show taht data. Now we do:

For comparison here is the same data as a time-series graph:

The step-plot is usable for time-series and numerical XY data series. The format is detailed on the usual chart format pages.

sqlDashboards 1.41 Released

sqlDashboards 1.41 has been released and is available to download.

Changes include:

• Support custom JDBC drivers and Authentication Services
• Fix refresh rate display bug when widget is selected
• Fix sqlchart.bat to allow running from any current path

The custom JDBC/security has been asked for a couple of times but it’s inclusion at this stage is experimental. We do have a few customers using it with qStudio and documentation is available here. If this interests you get in touch.

SQL Pie Chart MYSQL

I came across this interesting post on ASCII pie charts for MySQL. I thought I’d use our command line tool sqlChart todraw the database pie chart instead.

[raw]
<br /> c:\Program Files (x86)\TimeStored.com\sqlDashboards>mysql -s mysql -u root –password=pp -D sakila<br /> -e “SELECT * FROM (SELECT table_name,data_length + index_length AS size FROM information_schema.TABLES WHERE table_schema = ‘sakila’) a<br /> WHERE SIZE IS NOT NULL ORDER BY SIZE DESC LIMIT 8”</p> <p>table_name size<br /> rental 2850816<br /> payment 2228224<br /> inventory 376832<br /> film_text 325440<br /> film_actor 278528<br /> film 278528<br /> customer 131072<br /> staff 98304</p> <p>c:\Program Files (x86)\TimeStored.com\sqlDashboards>sqlchart -s mysql -u root –password=pp -D sakila -e “SELECT *<br /> FROM (SELECT table_name,data_length + index_length AS size FROM information_schema.TABLES WHERE table_schema = ‘sakila’) a<br /> WHERE SIZE IS NOT NULL ORDER BY SIZE DESC LIMIT 8” -o c:\temp\aa\sizes.png -c piechart<br /> c:\temp\aa\sizes.png<br />
[/raw]

Simply changing our mysql command to sqlchart and adding the additional arguments
"-o c:\temp\aa\sizes.png -c piechart"
gives us the following SQL Pie Chart:

MySQL Sakila Table Sizes Pie Chart

Notice because sqlchart’s command line arguments closely resemble the mysql command line options, we can quickly change the calls from querying to graphing.