LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 06-13-2012, 12:05 PM   #1
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 965

Rep: Reputation: 44
Smile MySQL DB to catalog and manage music record collection


Hi all!

I have been collecting music records (especially vinyls) for a while now and I have gathered quite a lot of them. As you probably know, there are literally hundreds of them out there, with most of them having variants (such as from a different editor, different country or simply there are several versions on the market). Dozens of websites are "cataloging" these thousands records and have throughout the years gathered quite a bit of info, but none of them have all under the "same roof".

I am NOT collecting records for all types of music, only metal therefore I think what I want to do is "doable". I actually started gathering all the info in a excel spreadsheet, but its not easy to insert new info and update/search, and it does not have reporting features such as how many records I am missing in a single release, etc..

So I am either searching for a ready solution (either a binary or a libreoffice/openoffice database), a Java based solution, or if there are nothing like that available, build my own thing with MySQL as the database backend. For the frontend, I have NO clue!!

So anybody have done that before/are interested?
Thanks!
 
Old 06-13-2012, 12:28 PM   #2
Kustom42
Senior Member
 
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,563

Rep: Reputation: 410Reputation: 410Reputation: 410Reputation: 410Reputation: 410
PHP/MySQL would do the trick for you but you would need to have the knowledge to be able to create the queries you need to get the info you want.
 
Old 06-14-2012, 04:16 AM   #3
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 965

Original Poster
Rep: Reputation: 44
Yeah PHP coding would be nice but it's currently a bit above my capabilities .. you wouldn't be aware of a project like that by any chance? ?
 
Old 12-30-2012, 12:23 PM   #4
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 965

Original Poster
Rep: Reputation: 44
Just for the sake of closing this thread, I have been using Headphones and I love it!!

https://github.com/rembo10/headphones
 
  


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
LXer: Using MySQL to manage your music collection on Amarok LXer Syndicated Linux News 0 10-18-2011 10:01 PM
LXer: Manage your Movie Collection with Griffith LXer Syndicated Linux News 2 02-23-2008 02:02 PM
Catalog files on Harddrives (music) RemusX2 Linux - Software 1 11-11-2006 12:37 PM
catalog dvd collection? SharpyWarpy Linux - Software 8 05-30-2005 03:46 PM
catalog music cds SharpyWarpy Linux - General 0 04-29-2004 07:40 AM


All times are GMT -5. The time now is 08:22 PM.

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