Tag Archive: PHP


Now my 2nd Raspberry Pi has turned up I can (re)start work on my home automation project.

Previously I’ve setup a wireless sensor network (WSN) comprised of a number of jeenodes (http://www.jeelabs.org) using the RFM12B to connect back to central jeelink usb plugged into a repurposed orange livebox router (running http://www.homeautomationhub.com). Additionally I installed a number of CurrentCost individual appliance monitors (iams) and a EnviR energy monitor plugged into the home automation hub (hah) to monitor and log household and appliance level energy consumption. Refer to some old blog entries: https://tickett.wordpress.com/category/home-automation/. All of the data was being sent to pachube for logging.

I wasn’t too keen on the home automation hub as I didn’t really fully understand it and couldn’t push it where I wanted to go (although the community was really good and I imagine I will be seeking assistance from them in connection with the new project :)

In my new setup I intend to use a Raspberry Pi the "hub"- with a "full blown" linux distribution (debian?) I should hopefully be able to accomplish everything I am looking for. As python is the first language discussed in conjunction with the raspi I’ve started playing with that, but eventually may move to a LAMP solution (php with mysql backend for logging and apache web front end).

Here’s a high level summary of the steps I’ve covered:

The python example from the link above didn’t produce any output for me so I modified it slightly:

import serial, sys
ser = serial.Serial('/dev/ttyUSB0', 57600)
while 1 :
sys.stdout.write(ser.readline())

That’s all I have time for now- watch this space.

L

I’m still yet to find a decent replacement for Google Powermeter (i’m starting to think i’ll need to write something myself… php/mySQL possibly?)

Anyway- i’ve noticed my baseline (always on) power consumption is pretty high so picked up an extension lead from maplin http://www.maplin.co.uk/power-strip-with-energy-and-co2-meter-348228 (£12.99) with a built in display (current consumption, max consumption, cumulative consumption, power factor etc) to check all of my devices to see where I might be able to realize some improvements.

Here’s what I found with some commentary:

Fish Tank Pump: 4W (Reasonable & not really optional)
32″ TV Standby: 4W (Not great but it’s normally turned off at the mains not left on standby)- On: 110W (Pretty poor but it is relatively old tech)
Sky+ Box: 20W (Appeared to draw the same power whilst in standby and whilst in use)
Clarke Tech 9000 HD Satellite Receiver Standby: 26W- On: 31W
42″ LG TV Standby: 1W (Expected for a relatively recent model)- On: 68W (Not bad considering it’s not LED backlit)
Boiler Idle: 3W
50″ Panasonic Plasma TV Standby: 20W (Very poor, but unsurprising for old tech)- On: 400W (ouch!)
Mordaunt Short Subwoofer Standy: 3W (Seems reasonable with the auto-on feature active)- On: 18W
Acer Revo r3610 XBMC HTPC Off: 3W- Idle: 32W- Watching a movie: 28W (why it uses more power when idle than whilst playing a movie i will never know?)
Mini TP-Link 5port Gigabit Switch: 2W (impressive!)
Linksys Enterprises Managed 24Port Switch w/POE : 41W (expected this- may do some research into alternatives)
4×4 HDMI Matrix Switch: 14W
Nintendo Wii Off: 3W- On: 16W
Onkyo 608SR Amp Off: 0W (impressive!)- On: 45W- Playing Loud: 55W
Netgear Router: 10W
HP Proliant Microserver in use: 40W (impressive!)
Giant American Style Samsung Fridge Freezer: 100W (pretty good from what i understand)
Dell Poweredge 2950 III Off: 30W (ouch- this is with both PSUs plugged in- i have already ordered replacement Supermicro servers which I believe use 40W roughly whilst on/idle!)- On: 350W (ouchhhhhh!)

That’s about all… We know the usual appliances: Kettle, Oven, Microwave, Toaster, Washing Machine, Tumble Dryer, Hover, Hair Dryer etc draw ridiculous amounts of power but I was predominantly interested in always on devices. I will try and add some makes/models above where i haven’t already put details. If you can recommend any green devices please do share!

L

Project Dedupe

Further to my previous entry about migrating my sites to a new hosting provider I have now resurrected the “Project Dedupe” wiki: http://dedupe.tickett.net

I started the project in 2006 while I was working on a data migration project and trying to dedupe a large dataset. From sourceforge:

“The project will be looking at data (the intention is to begin looking at customer name/address data but this may widen over time) and ways to intelligently detect duplicates using fuzzy matching methods and algorithms.”

Dedupe_screenshot.jpg

I have no immediate plans to resume work on the project (other commitments)- but it’s out there for anyone to get involved.

L

%d bloggers like this: