Hacker News new | ask | show | jobs
by jhacobian 3488 days ago
When you team Grafana up with a general purpose database like Crate.io some pretty amazing things can happen. Not only can crate just "roll with the punches" of auto-sharding whilst dynamically scaling performance over N number of database nodes, it also possesses powerful aggregation capabilities. If that weren't enough, crate also dynamically gzips data by default which is impressive given its zippy performance.

You get all of this for free with Crate.io without giving up the flexibility of a general purpose SQL database...

Wanna start storing log data in crate as well? No problem! Just design your table schema, and API ingest layer (My favorite is NodeJS) but you can use any language you like.

Or if security (facing the public) isn't an issue (if you're on a subnet safe from the public internet) then you can certainly just use the built-in REST API which crate exposes.

With Crate, I've been able to store hundreds of GB of systems log data without worrying about silly things like table-bloat (the autosharding of partitioned tables handles the spectre of bloated table shards for me for free).

Thanks to the amazing developers over at Crate.io for taking the best of Elasticsearch and making it sane, fast, and chock-ful of SQL goodness!

Also a big thank you to the Grafana team for recognizing the potential synergies that Crate.io & Grafana could catalyse for unifying time-series & log data streams.