How can I handle video files with MySQL.?

Question

Is it possible?

What i want to do is, for example when I read the video file, depending on the users' internet s[eed, convert the video into suitable format for example avi or mpeg, or quick time and compress accordingly on the fly (realtime).

Answer 1

Its probably best to store the video files in a folder on the web server and the store the path in the database.
for example
video/myvideo.avi (is where the file is stored on the web server)
then you put
video/myvideo.avi (in the field in the database for storage)
Then you use PHP to slot the path to the file into your web pages.

Answer 2

It depends on what you want to do. You can store the video files in mysql as blob or the best way will be to create a directory which will contain your video files and all you need to store in your database is the path to the videos

Answer 3

particularly, your prevalent objective question would have many solutions, in keeping with very own reports. MY rule of thumb once you won't be able to exactly describe a unmarried utilization for a clean gadget, is to circulate with a multi-center CPU, with the quickest uncooked velocity first, observed by potential of the main important Cache. do no longer subject approximately what share cores, seeing that maximum purposes will purely run on ONE. domicile windows will use 2, yet no longer probably plenty extra. The extra cores, the extra $$$ it is going to fee you. i'd choose for a three.0Ghz center velocity, a minimum of twin center, and look for the main important CACHE length you could out of your record. (i.e. a 512MB cache isn't just about as stable as a 2GB or maybe 4GB cache). Spend the money on CACHE, no longer cores! After 2 cores, it rather is all wasted skill in at present's purposes. (Photoshop is an exception while it particularly likes many cores, so evaluate it your worse case scenerio.)