Storing Sound (Media) files in MySQL
One of the most irritating problems with most multimedia programs is that the Music Database can't span more than 1 Physical disc. If you are storing say "ripped CD" WAV files you can use up a lot of disc space and it would be better to spread these over several discs.
Even if you use FLAC or Ogg Vorbis you might want your library to span multiple discs.
I'm just wondering if one could store these files as BLOBS or even as physical Links in a MySQL database (absolutely NO problem with MySQL spanning several discs) and could multimedia players be made to handle retrieving the media file (or it's link).
What I'd want is somebody who knows scripting to write a script that would retrieve the file I want to play from the MySql data base and then pass this as a parameter to the Multimedia player say Mplayer or whatever.
Any ideas on this one.
Thanks
-K
|