lizaoreo
Groupie
Joined: February 11 2013
Location: United States
Online Status: Offline
Posts: 75
|
| Posted: June 03 2013 at 09:53 | IP Logged
|
|
|
I've recently set up a MySQL database on my QNAP NAS.
I've built a monitor to read my power usage and written
the Arduino code and a PowerShell script that updates
that database with an update on power usage every minute.
While not implemented yet, need to wait till I got the
money to actually finish the hardware side of things, it
should be by the end of the month.
I got to thinking, it would be nice to note when lights
come on and go off in the database. I've already got
triggers for each light when the status changes to change
the color of the background for the button in the CC web
page, is there a way I can add sending an update to the
MySQL server telling it the light came on/went off at x
time?
|
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Programming
Topic: Updating a MySQL Database
