I am completely new to database. I require some information regarding where does the Facebook which stores millions and millions of pictures and videos. Do they store it in their database and then the images/videos gets retrieved through the query? I have read few times from some people that you should not store the images/videos in the database but they never mentioned why and where else should you store them if not in the database. Please provide me as much information as possibly you can. It’ll be highly appreciated.
Advertisement
Answer
Typically? As files. On a disk. Then store the paths to those files in a database for easy lookup. (Or store a key that can be used by some network service to find the file and stream it.)