undefined | Better HN

0 points120bits6y ago0 comments

Thanks, this will probably work for me. However, if the inserts are higher, I don't want to get notified that frequently. How would I add a periodic alerts to this? Thank you!

0 comments

3 comments · 1 top-level

porsager6y ago· 2 in thread

You could use a column/table to track notifications. Eg. have an alert_sent_at column on the alerts table. Then when the node service receives the notify on an insert you can defer based on any logic you need, and send notifications when needed by a query that fetches alerts with alert_sent_at = null.

120bitsOP6y ago

Thank you! Thank you so much :)

porsager6y ago

You're welcome. To ensure you're not sending alerts twice either select and update in a transaction or use a CTE like:

  with alert as (
    select alert_id from alerts 
    where alert_sent_at is null
  )
  
  update alerts set
    alert_sent_at = now()
  from alert
  returning *

j / k navigate · click thread line to collapse