Accessing Our Sensor Data: PHP + SQLite + SVG

So we have our sensor(s) dutifully logging their data to an SQLite database. Now we need to process and view this data. LASP First we need to set our Raspberry Pi up as a webserver. This typically requires: Linux, Apache, MySQL and PHP - a LAMP framework. There is a handy guide: here (thanks Dave!). … Continue reading Accessing Our Sensor Data: PHP + SQLite + SVG →

Databases for Sensor Data in Python

Here are some options to persistently store sensor data in a database using python. Anydbm For simple key-value pairs the anydbm module looks the best. It stores values as strings. Because of this you may need to use another module called pickle to convert non-string values into strings. For example: import anydbm, pickle from datetime … Continue reading Databases for Sensor Data in Python →

Simple Energy Monitoring on Raspberry Pi

So. Reading an LCD screen was more difficult than I first assumed. My code is still good for reading my Thermostat values. However for energy monitoring and £20 I found a better solution. Looking on the net a particular model of energy monitor was recommended for easy monitoring: the Current Cost EnviR. This monitor has … Continue reading Simple Energy Monitoring on Raspberry Pi →

Home Inputs & Outputs

If thinking about the home as a system I need to look at Input/Output (I/O) options. If using a biological model the inputs map to senses and the outputs to muscles and nervous system control. I do not have all these items but hear are some ideas. Inputs Energy Monitor e.g. Owl via CM 160 … Continue reading Home Inputs & Outputs →

Programming a Raspberry Pi from the Sofa

I have set up quite a nifty little workflow for interfacing and programming the Raspberry Pi. SSH Access I have set up the Pi with a static IP address and configured SSH access. Setting up a static IP address is easy with an AirPort Extreme. Using AirPort Utility goto Advanced options>DHCP and NAT>Reservations. Set up … Continue reading Programming a Raspberry Pi from the Sofa →

WeMo Motion / IFTTT Bugs

Just bought the WeMo Switch and Motion sensor. Setup was fine via app. Next step was connecting IFTTT. I did this via the "...More" button on the app. Click on "Connect to IFTTT" option. A pin is generated. It took me a couple of attempts to realise you can click on the button under the … Continue reading WeMo Motion / IFTTT Bugs →