I’ve discovered a wonderful and detailed explanation of diffraction in photographic lenses and how calculate the effect relative to the pixel scale of your sensor. It also includes a couple of nice interactive examples and an online calculator.