Tag Archive for 'mysql'

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


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