I think perhaps you mean Lightroom vs Aperature?

Photoshop is photo editing / graphics software

Lightroom and Aperature (I believe, I don't use either of them) are for cataloging, categorizing, and organizing, though they have some simple editing capabilities.