LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Suse/Novell
User Name
Password
Suse/Novell This Forum is for the discussion of Suse Linux.

Notices

Reply
 
LinkBack Search this Thread
Old 04-04-2006, 08:46 AM   #1
1kyle
Member
 
Registered: Feb 2004
Location: 'Ol Blighty
Distribution: SLED 10, SUSE 10.3
Posts: 722

Rep: Reputation: 32
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
 
Old 04-04-2006, 09:02 AM   #2
onjoo
Member
 
Registered: Jan 2005
Location: Finland
Distribution: Suse 10, Suse-factory , RHEL4, SLES9, SLED10
Posts: 380

Rep: Reputation: 30
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
 
Old 04-04-2006, 09:44 AM   #3
1kyle
Member
 
Registered: Feb 2004
Location: 'Ol Blighty
Distribution: SLED 10, SUSE 10.3
Posts: 722

Original Poster
Rep: Reputation: 32
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Storing Images in MySQL MRMadhav Programming 14 03-01-2006 11:13 AM
Storing BibTex bst files in home directory drben Linux - Software 1 11-01-2005 02:31 PM
Storing sound settings for the secondary audio device? Livino Linux - Hardware 1 11-24-2004 06:07 PM
Storing files from linux to NT buddy Linux - General 3 01-15-2003 05:36 PM
storing multiple values within one field in mysql antken Programming 8 12-15-2002 10:08 PM


All times are GMT -5. The time now is 05:29 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration