The web of D-branes at singularities in compact Calabi-Yau manifolds