Discuss: database for metrics (influxdb)

skopjehacklab / status-old

dashboard for hacklab status information (temperature, people, open/closed, budget, etc…)

http://status.spodeli.org

0 stars 0 forks source link

Discuss: database for metrics (influxdb) #1

Closed gdamjan closed 8 years ago

gdamjan commented 9 years ago

Influxdb - already has an http api, so that part would be done

@spion: +1 influxdb (easy to install, fairly powerful queries, HTTP api)

алтернатива: sqlite - more battle tested and with more examples and resources available, and the best manual :)

@damjan I had the same arguments for influxdb. Using anything else would require implementing a publicity* API and also documenting it.

publicity - in the sense we want to make the data freely and simply available to anyone

gdamjan commented 8 years ago

influxdb installed, public data accessible at:

curl -i -G 'https://db.softver.org.mk/influxdb/query?pretty=true' \
   --data-urlencode "db=status" \
   --data-urlencode "q=SELECT * FROM temperatures"

db is populated by https://github.com/skopjehacklab/kika-info-bus/tree/master/influxdb-logger

gdamjan commented 8 years ago

also

curl -i -G 'https://db.softver.org.mk/influxdb/query?pretty=true' \
   --data-urlencode "db=status" \
   --data-urlencode "q=SELECT * FROM landevices"