Smart House: Why? How?
I want some simple functions for the H33 house: Energy monitoring: easy with Phisaver at the switchboard House off: turn off all […]
Category: Computing
Django Development and Staging
I have two boxes: dev and production. I need a very simple method for working on the dev machine and then pushing […]
Postgres Tricks
Log-the-frick-in sudo -u postgres psql dbname # typical root user psql -h localhost -U user -W dbname # default host is unix-domain […]
Why the hell can’t I login to PostgreSQL?
Some possible reasons and solutions Wrong host Use the “-h” flag: psql -h localhost -U phisaver –password Wrong syntax Use -U and […]
Periodic Emails with Django
Rough notes on meeting these requirements: Using Django Send weekly / daily emails to someone Log results Be robust and simple Packages […]
WordPress Setup (and Migration)
WordPress: meh. But anyway:
Energy Dashboards
Currently (2021) PhiSaver has one billlion data points. It’s a bit hard to display in a single user dashboard. An efficient user […]
InfluxDB v2 (Flux) Setup for Energy and Power Data from Iotawatt
This are my notes on setting up InfluxDBv2 for storing Iotawatt power readings. Specifically I needed to: Transition a live site from […]
Enclosures for electronics and RF
Investigations into using ABS, polycarbonate and sheet metal enclosures to house electronics with a focus on getting that radio signal (wifi, 3G/4G) […]
OpenVPN for IoT : Linux Server, Various Clients including RaspiZero
Using a AWS Linux server, and Raspberry Pi Zero clients Situation Goals Solution Details Setup OpenVPN Server and CA add_client.sh Run on […]