Database design best practice

[Todd6808807]

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

[Evgene Karachevtsev]

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?

[Todd6808807]

Thanks for responding Evgene,

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

[Todd6808807]

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

[Kateryna Grynko]

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.

[Todd6808807]

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

[Alena Prykhodko]

Both are applicable.