Saving multiple pictures for a website that will work like an ecommerce [duplicate]

Question

I am developing a website that will work a little bit like ecommerce. It is a website where people will upload picture of items they want people to buy. My challenge is that when learning Mysql database storage, I learnt that mysql can store pictures but it is better to use it for only profile pictures. Storing large amount picture in mysql will slow it down. Please, what do i use to store these pictures and how? I have learned PHP, JSON and mysql

Answer 1

This question comes up regularly and the short answer is: it depends. It's a question of weighing up between an "all-in-db approach" and "which component can do what best". The bias seems to be towards "store in file system". It further depends on the average size of your images and your MySQL setup. Make sure to read up on the BLOB field type and object storage in general.

• Storing images in MySQL
• Storing image data in a MySQL database?

From your question I can't really tell where on your developer journey you are. But given your comment it might be helpful to point out that MySQL isn't a ready-made web-app in itself. MySQL can be one element in a solution stack (LAMP for example) and be the "database part". In a web-app where front-end code collects a user's uploaded data, your code can then store this user data into a back-end system like a database, which is MySQL, or into the file-system - that's on you as developer.