I am designing a database for an eCommerce website.
How can I store images, audio, video and PDF files which are uploaded from the online users, in a MySQL database?
I am using the InnoDB storage engine. While surfing on the Internet, I got the following answers:
- I can store these files using BLOBs.
- I can use the
Varchardatatype to store the physical path to store these files.
According to my previous experience storing the files on the database has some issues while retrieving that files (sometimes I got broken files).
What is the best practice to store these files in my MySQL database? As I am beginner, I need to know the performance implications for my database in such situations.