Keeping a cache of “users who have blocked me” for every user is probably not that expensive. If Bob blocks Oscar, update Oscar’s row to add Bob to Oscar’s bloc

Keeping a cache of “users who have blocked me” for every user is probably not that expensive. If Bob blocks Oscar, update Oscar’s row to add Bob to Oscar’s blocked_by list.