-2

I am given to know that video blobs should not be stored in MySQL. But what if the video is very small with a maximum length of 5 seconds. Is it okay to store small videos(less than 5 seconds) as blobs in mysql?

Filburt
  • 17,626
  • 12
  • 64
  • 115
Abhijith
  • 69
  • 4

1 Answers1

2

It's okay to store media data as a BLOB, regardless of length, as long as the content isn't larger than the maximum size for the data type (64KB for BLOB, 16MB for MEDIUMBLOB, 4GB for LONGBLOB).

Many software developers will insist that media belongs in files, not in the database, but there are good reasons to store data in a database too.

This is basically a matter of opinion. The best solution for your project may be different from their project.

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828