I’m already using InfluxDB 1.x for classic timeseries stuff such as server and performance monitoring. I just started playing around with InfluxDB 2 and love exploring all the new possibilities.
I was wondering if InfluxDB 2 is also a good tool for processing event streams. In my perticular case the events happen irregular in time and consist of a category and an action enriched by various metadata. Here’s an example:
- Door, opened, door_id = 42
- Light, swiched_on, lamp_id=23, brightness = 255
- Light, swiched_off, lamp_id=23
- Door, closed, door_id = 42
This kind of event stream needs to be processed afterwards (but not in realtime) to find defined patterns, e.g. create a “Room used” event if the door was opend for at least 5 minutes and the light was on.
If InfluxDB 2 e.g. with tasks is the right tool for it: What would be a good approach to achieve this?
Many thanks in advance!