search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.33k stars 869 forks source link

Is alerts feature over data in the roadmap? #283

Open jfcalvo opened 6 years ago

jfcalvo commented 6 years ago

Alerts over db data is a common feature in TSDBs.

Is there as feature in the roadmap? If not what is the alternative at the moment to implements alerts over DB data?

i.e: (Using conditions examples from tutorial) Notify me when the average temperature in a week is bigger than 30º.

mfreed commented 6 years ago

Hi @jfcalvo, thanks for the interest.

Can you describe the context which you are looking for alerts? (i.e., dashboarding, downstream data pipeline, email, etc.). I ask because many systems integrate them slightly differently, and there are some natural integrations that already work simply through Timescale's SQL interface.

jfcalvo commented 6 years ago

For my personal use case I would prefer something that could define custom alerts and be notified via HTTP post to my app so I don't need to do something like execute a SQL query in a time interval and process the result.

What is the best approach to do something similar to what I have defined? I have tough in declare triggers and integrate them with Postgres NOTIFY/LISTEN but I don't know if there is something simpler to solve the problem.

mfreed commented 6 years ago

Thanks for the feedback, @jfcalvo. We'll give this some thought about how / when we want to support alerts more out-of-the-box.

Dyzz1995 commented 6 years ago

How can i generate alerts about rules in TimescaleDB? I need to create a rule, and when this rule is broken i want generate a post notification. For example: i want to create a rule that verify if the average temperature in the last 5 minutes of a device D exceeds X, then I want to detect in order to be able to react. Is this possible?

ipasic commented 5 years ago

Hi, I also find this as very useful feature to have and hope you will consider developing something similar in future.

dianasaur323 commented 5 years ago

Quick update here - now actively working on this. If you're interested in getting an earlier look at the design, happy to share that when ready. Please send how you want to be contacted to diana at timescale.com

remarkpk commented 4 years ago

Any more info on this feature? I would like to be able to create alerts for metrics when temperature is sustained for a certain period if time, etc.

jacwak commented 4 years ago

This will take the product to another level. Also, it a must-have feature in today's systems.

bloever commented 3 years ago

Any news about this feature?