user660943
user660943

Reputation: 85

How to store an MP3 file in a a database?

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.

Upvotes: 5

Views: 6736

Answers (1)

vickirk
vickirk

Reputation: 4067

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

Upvotes: 6

Related Questions