LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
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
 
Search this Thread
Old 11-14-2013, 11:33 AM   #1
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 970

Rep: Reputation: 44
Recommendations for a music record collection manager that uses PHP/MySQL


We are basically searching for a solution to catalog a large dynamic collection of vinyl records (3000+). We are several people in need of a common solution... Basically from different physical locations, people will enter/delete/edit records in the central database.

This is for a small record store.

Because our server runs Percona MySQL, we insist in a solution that would use a MySQL database to store the info. Ideally, it should be a web based solution to allow access to the database & adding/editing entries without having to install a special software on the computers...

This is why I have indicated php in the thread title.

Are you guys aware of such solution? Doesnt have to be specifically for a vinyl record collection but it can be for any type of collection provided it is generic enough (for example a wine collection manager wouldnt work well to catalog music records)...

I believe this will be a short topic if such solutions exists... I have searched on google for weeks, but so far the only potential workaround I have found would be to code something myself which is impossible considering my curent php/database knowledge...

So to summarize:

Ideally web based (php) to eliminate the need of specific software installations and allow access from anywhere & remotely...
Using MySQL to allow remote access and easy cataloging / backup of the DB
Tailored toward vinyl records is a major PLUS

Im waiting for some ideas!
 
Old 11-14-2013, 09:33 PM   #2
baldur_1
Member
 
Registered: Sep 2010
Posts: 51

Rep: Reputation: 5
it would be pretty easy to configure a drupal website using mysql on the backend and i think there would be plenty of support. to host it use (apache) https. https creates the security blanket, a mysql server stores and catalogs...and drupal is the face of it. i haven't done this but i think it would be pretty easy and you would find decent support for drupal.
 
1 members found this post helpful.
Old 11-18-2013, 08:33 AM   #3
lpallard
Member
 
Registered: Nov 2008
Location: Milky Way
Distribution: Slackware (various releases)
Posts: 970

Original Poster
Rep: Reputation: 44
baldur_1, that was an excellent suggestion!!

I installed drupal, created the necessary database config, installed all necessary modules and created a view then created an input form for new crecord in the DB, then started using it.

So far, I almost have a professional grade solution at hand, only next is to fine tune the attributes and the way I want to use the info I enter in the DB.

I couldnt have done better with a paid solution I think

I rarely do recommend something just because everyone's needs are different, but I will do it this time: I HIGHLY recommend drupal !!! Fantastic framework.

Thanks again for pointing me into this direction!!
 
1 members found this post helpful.
Old 11-18-2013, 08:12 PM   #4
Buckyjunior
Member
 
Registered: Jul 2003
Distribution: Kubuntu Hardy
Posts: 76

Rep: Reputation: 15
How cool is that? Question. Solution.

The title of the thread was interesting because I got tired of re-typing (typewriter) my 25+ pages when I picked up a new LP. Most of it all is now digital—and cataloged digitally so I still don't have my LPs properly cataloged. Now I have a new idea.

Thanks Baldur_1.
 
  


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] MySQL DB to catalog and manage music record collection lpallard Linux - Software 3 12-30-2012 12:23 PM
PHP MySQL Movie Collection kenshi Linux - Software 2 12-13-2012 06:47 PM
LXer: Using MySQL to manage your music collection on Amarok LXer Syndicated Linux News 0 10-18-2011 10:01 PM
clean music collection edgjerp Linux - Software 5 12-04-2007 02:38 AM
my music collection Killer Penguin Linux - Software 10 10-06-2006 06:24 AM


All times are GMT -5. The time now is 05:05 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