Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: home automation (reset)

Weather station
+0 Vote Up -0Vote Down

I wanted to add a weather station to my home automation system for a number of reasons...

  • watering lawn (temperature, season, moisture, dew point)
  • weather (temperature, chance of rain)
  • historical (collect data over years)

In 2006, I bought the weather station WS2300 and integrated it in a number of ways.

  • I have a sizable MySQL database, so using the mysql2300 module, I stick weather data into the database every 10 minutes

read more

Water the lawn if temperature exceeded 80 degrees
+0 Vote Up -0Vote Down

I read somewhere that you should do extra watering of lawn (after sunset), if the temperature exceeded 80° F during the day.

So, a really quick hack works like this:

A bash script
#!/bin/bash

TEMP="`/usr/bin/mysql -ss open2300 -e \"SELECT FLOOR(MAX(temp_out)) FROM weather GROUP BY (rec_date) ORDER BY rec_date DESC LIMIT 1;\"`"
if [ "$TEMP" -ge 80 ]; then
/root/water-on.exp
/root/water2.exp 120 1
/root/water3.exp 120 1
fi

read more

What Marc Fleury did next
+0 Vote Up -0Vote Down

We knew Marc Fleury couldn’t stay out of the business world for long. The founder of JBoss has leaked details of his new venture, an open source home automation community named OpenRemote.

The OpenRemote team also includes the creator of Asterisk Mark Spencer, JBoss veterans Juha Lindfors, Christian Bauer, Java X10 project creator Wade Wassenberg, and Linux Home Automation founder Neil Cherry.

Together they, and others, plan to create a complete open source home automation including the OpenRemote Controller hardware, OpenRemote Console Applications to make use of the iPhone and iTouch as a universal remote (although any device with browser will work), the

  [Read more...]
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.