Dear HG Forum,
This is my first post and hence please bear with me while I ramp up on HG.
I have successfully integrated HG with a few Z-Wave based sensors.
I also have some existing sensors that are dumping data to a MySQL database. I would like to add a widget on my home screen to visualize the data from my MySQL database. Could you please advise me on how to do that ?
Database schema :
# Structure for table "sensordata"
#
DROP TABLE IF EXISTS `sensordata`;
CREATE TABLE `sensordata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gatewayid` int(11) DEFAULT NULL,
`temperature` int(11) DEFAULT NULL,
`light` int(11) DEFAULT NULL,
`date_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
# Structure for table "weather"
#
DROP TABLE IF EXISTS `weather`;
CREATE TABLE `weather` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date_time` datetime DEFAULT NULL,
`longitude` int(11) DEFAULT NULL,
`latitude` int(11) DEFAULT NULL,
`temperature` int(11) DEFAULT NULL,
`temperature_min` int(11) DEFAULT NULL,
`temperature_max` int(11) DEFAULT NULL,
`zipcode` int(11) DEFAULT NULL,
`humidity` int(11) DEFAULT NULL,
`pressure` int(11) DEFAULT NULL,
`wind_speed` int(11) DEFAULT NULL,
`wind_deg` int(11) DEFAULT NULL,
`clouds` char(16) DEFAULT NULL,
`name` char(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=801 DEFAULT CHARSET=utf8;
