Differences

This shows you the differences between two versions of the page.

--- projects:internetofthings:influxdb [2017/11/18 08:37] – created scipio
+++ projects:internetofthings:influxdb [2019/09/24 11:07] (current) – [influxdb] scipio
@@ Line 29: / Line 29: @@
 >
+</code>
+select
+<code>
+influx -database test -execute 'select * from "mctc.veicoli.get" order by time desc limit 10'
 </code>
@@ Line 49: / Line 54: @@
 </code>
+retention
+<code>
+CREATE RETENTION POLICY "a_year" ON "test" DURATION 52w REPLICATION 1 SHARD DURATION 168h
+CREATE RETENTION POLICY "a_week" ON "test" DURATION 168h REPLICATION 1 SHARD DURATION 24h DEFAULT
+</code>
 ====== grafana ======
@@ Line 55: / Line 64: @@
 <code bash>
-echo "deb https://packagecloud.io/grafana/stable/debian/ jessie main" > /etc/apt/sources.list.d/grafana.list
+TODO
-curl https://packagecloud.io/gpg.key | sudo apt-key add -
-apt update
+# per rasp
-apt install -y grafana
+cd /tmp
+wget https://github.com/fg2it/grafana-on-raspberry/releases/download/v4.6.1/grafana_4.6.1_armhf.deb
+dpkg -i grafana_4.6.1_armhf.deb
 systemctl enable grafana-server
 systemctl start grafana-server