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.<p>You get all of this for free with Crate.io without giving up the
flexibility of a general purpose SQL database...<p>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.<p>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.<p>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).<p>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!<p>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.