TimescaleDB
Why not Influx I've been using Influx (v1 and v2). Flux is great but now (2025) unsupported. Influx has bugs with won't be fixed. The worst is duplicate points which means you can't rely on …
ARTICLES
IoT
ESP32 Cam OV5640 Board
Setup board is V1.2.1 with the OV5640AF (autofocus) pin out of this board ubuntu linux Getting Started Arduino IDE (quick and dirty) Install Follow the install instructions for Arduino. Add boards (File>Preferences>Boards URL) at https://espressif.github.io/a…
Timeseries Data Schema
Different code uses different formats for Time Series data. With query languages converted to, say, Python lists and dicts, the structure can depend on the query. The query can be dynamic and therefore the structure …
Testing a LilyGO: esp32+4g = 7670SA
References The Lily Docs Github LilyGO-T-A76XX Docs Github Lig Libig Product: t-sim-a7670e There are heaps of models. Mine is 7670-R2-SA. SA is South America (also Australia). R2 is maybe revision 2? First Steps Following "Quick …
Multi-Tenant Grafana with DRF
While looking at Grafana Multi-Tenant arrangements, I realised it's problematic to have a multi-tenant SQL database accessed by Grafana. One solution is to use the X-GRAFANA-USER. If we can trust this header it will allow …
Grafana Multi-Tenant
Teams, Folders, Organisations ... and Provisioning. What's up with that? I use Grafana to display data about IoT devices (PhiSaver). It's all stored in a single DB. This Db cannot have access controls, so access …
Complex Electricity Metering
How to get meaningful energy efficiency results when there is a spaghetti of boards A more complex schematic - what should we meter? Look at that mess! We focus on the result , not just …
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 lights (and maybe A/C, vent, etc) with a single switch Ventilation: run the …
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 (not tcp to localhost) More detail here. Create read-only user # login to …
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 dashboard should answer questions. This page charts my progress to the mythical perfect …
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 InfluxDB1 to InfluxDB2 Setup InfluxDBv2 to use InfluxDBv1 api and auth, so that …
Raspi (Zero W or Rpi 4) router with wlan1 Wifi Dongle
Pi Zero There are a few options to do this. I used the official documentation and adapted it to create a script: https://gist.github.com/brettbeeson/4ecf4eb21b39f502a4c50bd1e196e90c On the Raspi Zero W, plug in a USB OTG adaptor and …