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

@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

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

New #Blog: Improving our Solar Battery Savings
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/house-stuff/improving-the-energy-savings-delivered-by-our-solar-battery.html

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

New #Blog: Writing data from a Bip 3 Smartwatch into InfluxDB
Author: Ben Tasker

https://www.bentasker.co.uk/posts/blog/software-development/extracting-data-from-zepp-app-for-local-storage-in-influxdb.html

#android #data #databases #gadgetbridge #grafana #health #influxdb #influxql #kubernetes #metrics #reverseengineering #wearables #zepp

Is there actually anyone using #Tasmota and #influxdb with #flux queries to query/visualize data? I can do bare minimum with current power and total power today/yesterday - but not much more like calculating energy cost, monthly sums, etc. Every tutorial either uses outdated #influxql or #prometheus instead :-(

Ich bin zu doof für #Flux
Ich bleibe bei #influxql

Finalement, il me reste à mieux comprendre les partitions (shards) et les politiques de conservation des données (retention policy) que je trouvais simple à configurer dans graphite.

L’idée est d’avoir une résolution :

- à 5 secondes pour les données très récentes
- à 10 secondes pour les données un peu plus anciennes
- et ainsi de suite

Voici quelques captures d’écrans pour illustrer

#supervision #métrologie #OpenNebula #LizardFS #telegraf #influxDB #grafana #influxQL #SQL #graphite

Je pense que les choses vont rester tel quel pour un moment :

- langage de requête sympa d’influxDB influxQL ressemblant à du SQL
- support des étiquettes pour des requêtes plus sympa
- 300Mo de stockage de données là ou go-carbon/carbonapi ont très vite utilisé 20Go

https://docs.influxdata.com/influxdb/v1.8/query_language/explore-data/

#supervision #métrologie #OpenNebula #LizardFS #telegraf #influxDB #grafana #influxQL #SQL