INFLUXDB :: FINE DUST

influx

> precision rfc3339

> show databases
name: databases
name
----
_internal
luftdaten

> use luftdaten
Using database luftdaten

> show measurements
name: measurements
name
----
feinstaub

> select * from feinstaub limit 1
name: feinstaub
time                           SDS_P1 SDS_P2 humidity max_micro min_micro node           samples signal temperature
----                           ------ ------ -------- --------- --------- ----           ------- ------ -----------
2019-05-18T06:01:18.601462447Z 13.03  11.8   99.9     404499    76        esp8266-99999999 1819630 -65    15.2

> SHOW SERIES
key
---
feinstaub,node=esp8266-99999999

> SHOW RETENTION POLICIES
name    duration shardGroupDuration replicaN default
----    -------- ------------------ -------- -------
autogen 96h0m0s  24h0m0s            1        true

# ALTER RETENTION POLICIES
# --> https://docs.influxdata.com/influxdb/v1.7/query_language/database_management/#modify-retention-policies-with-alter-retention-policy

> DROP MEASUREMENT feinstaub