Forum | Appery.io

Hi,

Im about to do the Camera Component tutorial & had a question around database design.

I have a need to store multiple photos per database record that also has some other fields.

So my question is should I create a separate db or even collection or simply add some fields into my existing collection?

Thanks in advance

Hello Todd,

You shouldn't create new database. Please tell us how do you keep the picture - as a file and in the collection you store the name of a file or in collection you keep base64encoded string with the content of the file?

Thanks for responding Evgene,

What would be best practice? Im happy to do whatever is best.

just a reminder that there may be up to 5 photos that relate to the record. For example a record in the collection might relate to an event. That event might have fields date, location & comments. Attached to that event can be up to the 5 photos.

Thanks

Hi Todd,

This depends on app logic. For example, you could store images in Database Files and store images names in a field of array type.

Thanks for your response I'm not sure what is the best way to go (even based on your above answer)

Both are applicable.