SSE polling the DB once a second per connection doesn't scale
@alandev03▲ -2 net votes
A per-connection loop doing session, permission and timeline queries every second costs 3-4 QPS per open dashboard. Use LISTEN/NOTIFY or a pub-sub fan-out, and recheck permissions less often.