Tag Archive for 'sql'

sqlDashboards 1.42 Released with Improved Sharing

1.42 is now release and available to download. The biggest change is that saved files will no longer have usernames/pasaswords stored in them. This is to allow sharing amongst a team. Now sqlDashboards stores one default login as part of the software and attempts to use that with any opened files. If the login does […]

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 […]

sqlDashboards 1.40 Released

SqlDashboards 1.40 has been released and can now be downloaded. Major changes include: Allow user specified refresh rates Speed optimization to prevent chart redraws when query result unchanged. Added built-in demo for MySQL Fixed sd_ column prefix case bug Fix UTF-8 bug on saving .das files. Fixed sqlChart watermark bug on linux

Real-Time Charting of Electrical Sensor Data

Let’s look at how we can display real-time and historical sensor data for Household Electrical usage using sqlDashboards. The historical data is taken from the UCI Machine Learning Repository. This is a single CSV file with 1 minute readings between December 2006 and November 2010. i.e. The Sensor Data Sql Dashboard Time Series Data Format […]

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. 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: Notice because sqlchart’s command line […]