New #Blog: Is Our Hot Tub Thermal Cover Worth The Cost?
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/house-stuff/will-our-hottub-thermal-cover-break-even.html?utm_source=rss

#analysis #electrical #hottub #housestuff #influxql

Wanted to switch from InfluxDB to TimescaleDB (because Influx kinda sucks) and was annoyed that I had to create all the tables by hand.

So I wrote a (kinda hacky) MQTT to TimescaleDB gateway where mqtt->table+field mapping is defined by code, and tables, fields and indices are created and extended automatically.

https://github.com/patagonaa/mqtt-timescaledb-gateway

#InfluxDB #InfluxQL #TimescaleDB #PostgreSQL #MQTT #NodeJS

AAAAAAHHhhhhh! Is there anybody out there....

... who is able to tell me how to connect a database to bucket? It's all about the reuse if grafana stuff using #influxQL to access a #influxdb bucket. (I switched to #influxdb 2.7 not thinking about the different internal data model.)

And yes I did research:
For example:
influx v1 dbrp list --org ORGNAME
gives: Error ..... 401 unauthorized

#retoot very appriciated

#influxdb #flux #influxQL #grafana

Ich schreie mal: AAAAAAHHhhhhh!

Gibt es hier jemand, der mir sagen kann wie ich in influxDB 2.7 einem bucket eine database zuweisen kann?

Hintergrund: Damit ich in Grafana mit influxQL auf die Daten zugreifen kann und und nicht flux nutzen muss...

#influxdb #flux #influxQL #grafana

New #Blog: Automating A Hot Tub With Home Assistant
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/house-stuff/automating-our-hottub-with-home-assistant.html

#automation #electrical #grafana #homeassistant #housestuff #influxdb #influxql #octopus

Our Solar Battery Started Kicking In Late
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/house-stuff/our-us2000c-batteries-stopped-kicking-in-on-schedule.html

#battery #electrical #housestuff #influxql #solar #troubleshooting

The only thing more frustrating than JOINs is encountering a SQL dialect that doesn't support them.

#InfluxDB #InfluxQL #SQL

New #Blog: Correcting My Grid Charge Calculations
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/house-stuff/correcting-my-battery-saving-grid-charge-calculations.html

#analysis #electrical #housestuff #influxdb #influxql #octopus #python #softwaredevelopment #solar

New #Blog: Shaving the Morning Peaks
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/house-stuff/charging-battery-from-the-grid-to-reduce-exposure-to-morning-peaks.html

#analysis #electrical #housestuff #influxql #octopus #solar