Is it possible to store multimedia files in database | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Is it possible to store multimedia files in database

24th Nov 2016, 3:42 AM
Athul P Ramachandran
Athul P Ramachandran - avatar
3 Answers
+ 2
yes you can. but its not advisable. what you can do is store the video file in the server and save the path of the video in the database.
24th Nov 2016, 5:10 AM
Junjie Gono
Junjie Gono - avatar
+ 2
You can store binary files in BLOB's in the database. Most database designers, though, do not put large files in a database since they tend to outweigh the structured data. For example, if you have a 100 tables that are under 10 megs, and a table with gigabytes of data, backing of the entire database means you need to be able to backup both the 100 tables and the giant table. Most designers put large files on disk somewhere which is why you unlikely to find much discussion of putting them in a database. Encryption is not supported on FILESTREAM data.
24th Nov 2016, 6:43 AM
Akwin Lopez
Akwin Lopez - avatar
+ 1
yep!
24th Nov 2016, 3:46 AM
Khan Samar
Khan Samar - avatar