Skip to content

Instantly share code, notes, and snippets.

Avatar

Lauri Kuittinen lauriku

View GitHub Profile
View keybase.md

Keybase proof

I hereby claim:

  • I am lauriku on github.
  • I am lauriku (https://keybase.io/lauriku) on keybase.
  • I have a public key ASDr38rG_KqvtiIGEHsrSgP8Zf6bdNB014OxU3pIfRuuUwo

To claim this, I am signing this object:

View influx.sql
# HTTP API via curl
curl -G 'http://<host>:<port>/query?pretty=true' --data-urlencode "db=gofore" --data-urlencode "q=SELECT * FROM temperature WHERE device_id='1000'"
# Queryt
select * from temperature where time > now() - 6h and device_id = "1"
select last(value) from temperature, co, humidity where time > now() - 1m​ group by *
show tag values from temperature with key = "device_id"