Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome Programming
 PowerHome Messageboard : PowerHome Programming
Subject Topic: Updating a MySQL Database Post ReplyPost New Topic
Message << Prev Topic | Next Topic >>

Joined: February 11 2013
Location: United States
Online Status: Offline
Posts: 75
Posted: June 03 2013 at 09:53 | IP Logged Quote lizaoreo

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
Back to Top View lizaoreo's Profile Search for other posts by lizaoreo

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum