Time series database Graphite seems to be falling into disfavor • Hacker News Board

Re: Time series database Graphite seems to be falling into disfavor

#81

Post by cbsmith » Thu, Nov 12, 2015, 3:09 AM UTC

chaotic-good wrote: post #80

cbsmith wrote: post #79

Earlier quoted context omitted.

The normalized data is the index. It can still be pointing to the raw data. The nice thing is that the index organizes the data in a way that makes it easily (lossless) compressible.

> It can still be pointing to the raw data. Yep. Each SAX word should be mapped to the list of seriesid:timestamp pairs. This list is often referred as postings list in information retrieval. The resulting data-structure is an inverted index. SAX and iSAX papers describes inverted index variant (really bad one) based on folder structure but one can use convenient IR tools for this.

iSAX2 yields a much better inverted index style model.

The thing is, particularly with time series data, a lot of times it is sufficient to at least start with the summary data in the index.

Re: Time series database Graphite seems to be falling into disfavor

#82

Post by gh02t » Thu, Nov 12, 2015, 7:15 PM UTC

emilburzo wrote: post #78

gh02t wrote: post #67

Earlier quoted context omitted.

Grafana is sort of that. It's a visualization tool that can use a bunch of different TSDBs as the backend. I use it with InfluxDB to track and plot sensor data from my home IoT setup. Basically all sensors (primarily temp because it controls my thermostat) are connected to an isolated WLAN and broadcast do their readings via MQTT. A process on the server collects them and stores them in Influx, which Grafana can use…

> sensor data from my home IoT setup Have you documented your setup anywhere? I'm DIY-ing something similar and I'm always curious how others have approached things.

I haven't, unfortunately. I'm planning on doing it eventually, but it'll probably be a while. The tl;dr though is a RasPi hosting a local-only wifi network and Mosquitto + ESP8266's everywhere. I was originally going to go for Arudino+NRF24 wireless, but ESP8266 is cheaper, smaller, longer range, simpler and still compatible with the Arduino library.

Re: Time series database Graphite seems to be falling into disfavor

#83

Post by Karunamon » Sat, Nov 14, 2015, 4:24 AM UTC

23david wrote: post #44

fapjacks wrote: post #31

Earlier quoted context omitted.

Kibana 4.x is atrocious . In addition to generally being as heavy as a ton of bricks.

I've been using the latest Grafana release as an alternative to Kibana for visualizations. It now supports Elasticsearch as a db backend. Seems much faster and more stable than Kibana 4.

Belated thanks for pointing this out! Grafana is now getting some serious play here, and it would get more if I could figure out how to make the term searches work :)