Lauri Kuittinen lauriku

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                lauriku
                / keybase.md
            
            
              Created
              December 22, 2017 11:37
            
          
    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:

  
## 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"
	# 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"