save photo or files in database

Hi Alex, For a ecommerce website, is it wise to save all the uploaded images to database in binary format, and later stream the to browser for display? The advantage of this solution is that all the digital asset eg. images can be managed in a central place. Will this solution possiblly cause any performance issue when traffic is high?

Posted almost 5 years ago by Eric Zhu
Posted almost 5 years ago by Alex Yang

I'm not sure about image loading performance when you're dealing with very high traffic situations (e.g. Pinterest, Instagram, etc). For most use cases, I think it's pretty standard to use something like Amazon Web Services for image hosting. It's easy to manage, integrates well with image processing gems like paperclip/carrierwave, and is relatively affordable.