#influxql — Public Fediverse posts

@PossiblyMax
> The #grafana graphs are super interesting (but tricky and confusing to write)
I'm using influxDB since 1 year and have only a diagram for power usage.
Would you mind sharing some dashboards or #influxQL you used?

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

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