Question

Photo of Hatim Motiwala

0

Profile Picture Storage

How are Profile Pictures Stored?

As binary data fields in SQL Tables or as disk files linked to fields in SQL tables?

  • Ken Roach

    And related is this question: when pictures are uploaded, does Rock adjust the data size of the pic uploaded? Does a hi-res pic take up more space than a low-res image? Is there any way to adjust or control this if it does? (E.g. 'Upload this image as a low res image')

  • Photo of Jim Michael

    2

    Rock gives you the option to store a File Type in the DB, on the file system, or in one of the third-party storage plugins available via the Rock shop. By default, person photos are stored in the db. Rock resizes the image physically but does not "optimize" the image in other space-saving ways. Here, we've chosen to purchase the Cloudinary storage plugin and move (via the Storage Mover plugin available in the shop) all person photos there, where it can store them as 10-15k files, optimized, and NOT in the db. It's a really nice setup. 

    Every file type in Rock can use a different storage provider, so how you set things up and where files go is entirely up to you, but "out of the box" you have only the two default options of DB or File System.