Store time-series data in Postgres, graph it in Grafana - Diana Hsieh

In this Meetup, Diana Hsieh (Head of Customer Success at Timescale) provides an overview of Grafana and how it works with Postgres and TimescaleDB, demoing the Postgres/TimescaleDB connector, new graphical query builder, and TimescaleDB specific capabilities and functions that make storing time-series data in Postgres not only possible but quite powerful.

𝐃𝐞𝐭𝐚𝐢𝐥𝐬:
Grafana is an immensely popular, open-source time-series data monitoring, and alerting tool. It allows for time-series data to be graphed and visualized in beautiful, flexible, repeatable ways. To date, many of the datasources that Grafana supports have been NoSQL in nature, with proprietary or customer query languages, and only recently did Grafana add support for Full SQL, relational datasources like Postgres.

Postgres is perfectly capable of storing and analyzing time-series data but at scale (50M+ rows) it is not so viable. With TimescaleDB, a Postgres extension purpose-built and proven for storing and analyzing time-series data in complex, ad hoc, and arbitrary ways, time-series data storage in Postgres is made possible. Grafana also becomes even more attractive for users of Postgres dealing with time-series data.

As a Postgres extension, TimescaleDB leverages the Postgres datasource to integrate with Grafana. The engineers at Timescale, together with Grafana, are working to continuously improve the experience of using TimescaleDB and Postgres with Grafana, and as of Grafana v5.3.0-beta1 (released a couple weeks ago), a graphical query builder for Postgres and first-class support for TimescaleDB were introduced.
𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐞𝐫: Diana Hsieh, Head of Product, Timescale

Diana wrangles product and customer success at Timescale. She spends much of her time talking to users to figure out how to make the product better. Prior to Timescale, she was a PM at Cockroach Labs, also based in New York. She has worked with tech companies for most of her career, starting out on the financial services side supporting and investing in enterprise startups. In her free time, she dabbles in jazz piano and blogging. She blogs both about product management and general database concepts.

Time-Series Data NY Meetup #3 - Two Sigma NYC - Sep 20 2018
https://www.meetup.com/time-series-data-new-york/events/254483484/

𝐀𝐛𝐨𝐮𝐭 𝐓𝐢𝐦𝐞𝐬𝐜𝐚𝐥𝐞𝐃𝐁:
TimescaleDB is the first time-series database specifically designed for scale, ease of use, complex queries.
https://www.timescale.com/

Видео Store time-series data in Postgres, graph it in Grafana - Diana Hsieh канала TimescaleDB