dispatch should be event-based

[yoe]

Currently, dispatch polls the database every 30 seconds. While that works, it has obvious drawbacks.

Instead, it should use Mojo::Pg::PubSub to listen for notifications, and the database should send those notifications from a trigger or some such. This will eliminate many delays.