New #Blog: Is Our Hot Tub Thermal Cover Worth The Cost?
Author: Ben Tasker
New #Blog: Is Our Hot Tub Thermal Cover Worth The Cost?
Author: Ben Tasker
@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.
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
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
#battery #electrical #housestuff #influxql #solar #troubleshooting
New #Blog: Correcting My Grid Charge Calculations
Author: Ben Tasker
#analysis #electrical #housestuff #influxdb #influxql #octopus #python #softwaredevelopment #solar
New #Blog: Shaving the Morning Peaks
Author: Ben Tasker
New #Blog: Improving our Solar Battery Savings
Author: Ben Tasker
#analysis #electrical #housestuff #influxdb #influxql #octopus #solar
New #Blog: Writing data from a Bip 3 Smartwatch into InfluxDB
Author: Ben Tasker
#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 :-(
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