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

Amarok can USE mysql and the data can be exported or used directly.
So This may help!?

http://amarok.kde.org/amarokwiki/index.php/MySQL_HowTo

Thanks -- That looks exactly what I'm looking for.

Never tried it before but I'll give it a go.

I really like the idea of using a MySQL database as I can then get all the track / album info as well.

I tend to keep Music (essentially ripped from CD's) in album order so I can even scan the CD cover and store that in the database as well.

(I'm running SUSE 10.0 with MySQL version 5 --stable as a rock. Suse 10.0 (DVD Evaluation edition) comes with MySql 4.1 but you can get 5.0 from the OSS 10.0 sources and this just installs with no problem.)

Thanks again

Cheers

-K