Movie preview project architecture help
I need to make a program that shows a list of movies and let the user preview them.
The way I thought to approach this, is to store the movie list in a mysql db - there will be several fields of information about each movie (artist,year,genre) and a BLOB field to hold the actual video.
what do you think about this approach?
would it be better if I store the files on the file system and just reference them from the database?
Another problem is what should/could I use to play the movies?
I could get the data stream from the BLOB and save it to file and then execute media player with the name of that file, but that seem wrong for several reasons: first I would rather have the movie play from a widget integrated in my app window, secondly I am afraid the whole process of saving to a file and then reading again will hinder the app experience unbearable.
I am a long time C++ programmer with very little experience with C#.