Multiple image upload approach laravel

Question

What's the best approach to store multiple images in database?

Upon browsing and searching for solution and approaches I found 2 options

first one is take the file name and concatenate and separate them using either comma or | but I'm having doubts since I think that's messy and would produce errors later in the system

second is I make another table for images and add foreign key (post_id) to know which post it belongs.

Any suggestion will be appreciated.

Just store your images as json. Perhaps under an images column, you can have {1: 'image1.png', 2: 'image2.png'} — Innovin
– Innovin, Commented Oct 23, 2022 at 19:48
Go with #2 - It's the correct relational design. And laravel can handle those "hasMany" and "belongsTo" relations quite well. — Paul Spiegel
– Paul Spiegel, Commented Oct 23, 2022 at 20:57

cengsemihsahin · Accepted Answer · 2022-10-23 20:02:32Z

1

Both methods work well. I would place the second.

It can also provide convenience when using some image upload plugins (filepond, dropzone etc.).

If I were to choose the first method, I would save the serialized arrays (with serialize()) for better bet.

answered Oct 23, 2022 at 20:02

cengsemihsahin

9753 gold badges10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ali Gulzar · Accepted Answer · 2022-10-24 04:54:30Z

1

Second one because it is normalized and you can have a better DX with that, No weird implementation to edit or any manipulation of post.

answered Oct 24, 2022 at 4:54

Ali Gulzar

513 bronze badges

Collectives™ on Stack Overflow

Multiple image upload approach laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related