I recently went through this as well. My wife and I shared iPhoto libraries for ~10 years and then they got to big. So I started splitting them into multiple l

I recently went through this as well. My wife and I shared iPhoto libraries for ~10 years and then they got to big. So I started splitting them into multiple libraries. Then the libraries (with dslr video) filled up the hard drive and my wife had trouble finding pictures she knew were there (but not in the current library ) After this a a couple of other things I settle on out current strategy: All old and new iPhoto libraries on an external HD connected to the home network. Aperture - I'm still learning how to use this so I can show my wife but it lets multiple people access multiple iPhoto libraries on multiple computers. The hard drive is wet her by the Crashplan daemon and everything gets backed up. As for phones and tablets, I'm pessimistic when it comes to photo stream: I see it as nice but ephemeral and regularly import the device images into the libraries. We will see how it goes as I learn more about Aperture.