I am making a web based Video On Demand App and I want to know what is the best way to store the videos.
I will be using a MySQL database and the videos in question will almost always we 1GB+ and there will be a lot of videos which will have to be stored.
What is the best way to go around doing this? I have searched and come up with a few ideas, but would like some advice before going ahead.
First idea I learnt is storing videos in the MySQL database itself using the LONGBLOB data type but I am not sure whether its the best option for such a big video library.
Second idea I learnt is storing the videos on the MySQL server. This seems more preferable to me but I am unsure as to how I would go about doing it.
Third idea I learnt is storing the file path in the database and just loading the video file like that. This would have been the most simple way, but I cannot do it this way because although the app is web-based, the final app will be running on a Samsung Smart TV (on my machine it will be running on an emulator and an emulator cannot access the hard disk, to my knowledge).
So in my opinion, storing on mySQL server would be the best option, but I don't really know how to do it.
Are there any other ways which I could use to accomplish what I need?
Any help would be appreciated. Thank you.
Aucun commentaire:
Enregistrer un commentaire