How to Get Stronger Consistency Out of a Datastore (2019)
blog.sentry.io
blog.sentry.io
Framing these problems slightly differently - is 10 second latency close enough to “real time”? - unlocks solutions like an online batch processor that reads out of your DB (if it doesn’t support NOTIFY) on an indexed incremental identifier.
/edit: actually, why does the "post process" consumer even cares about events not persisted yet?