Menu
Being new to storing data types in a database, I brought myself upon a problem whereas I need to store a media file inside some sort of database. I currently utilize MySQL. Since SO is a community which includes but is not limited to professional programmers, and one of the most high quality question and answer sites(as it pertains to programming), this question may have a fairly simple answer.
That being said, Someone explain to me how to store an abundance of media files inside an SQL database.
Please & Thank you to the stackoverflow.com community.
375
The typical pattern to follow when doing something like this is to save the MP3 (or any binary file) on the server in a particular directory, and save the path to the file in the database.
MySQL is fully capable of storing the full MP3 file as a BLOB, but can suffer some performance problems along the way. This part is an opinion based question -- there's no universal "right way", but most people I know would store the file on disk and only the path in the database.
Inside an MP3 file, music is stored as long strings of bits (binary numbers, zeros and ones) in a series of chunks called frames. Each frame starts with a short header (a kind of table of contents), followed by the music data itself.
To store the actual mp3 you need to store it as a blob. A common alternative is to just store a file path. I personally prefer the second approach if possible as they are a lot easier to work with when it comes to refactoring/deploying/testing
93
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
