l’m curious if anyone has ever tried using influx as an event store.
Basically I have a bunch of devices that emit state changes, but not full states. I would need a way to snapshot state from events stored in influx for a particular point in time. Do you see a possible way of doing this in influx?
For example, imagine the following table of events where id is the only tag and lines are ordered by time
id, propA, propB, propC
1, a, ,
2, , b,
1, a1, ,c
1, , b1 ,
If I query for the state of id=1 at a point in time after the latest insertion I would expect to see (a1, b1, c). Note that these measurements can be arbitrarily dispersed in time…