Hacker News Reader

This might be best done using triggers. I've had good experiences with the Hair Trigger gem for managing these in rails.

Trigger would work. But going the pg_notify approach could allow for asynchronous updating whereas the trigger approach could slow writes.