Store-Mp3

Introduction

In the past, I've had problems to store all my mp3 data in a file or something equal, which can easily be exchanged with my friends in order to let them know which mp3s I've got. Text files can be grepped very fast but the possibilities are quite limited and it's not very easy to find special groups or albums. A database was the ideal solution to store the id3tag in. I'm running a mysql-server on the web, so my friends can quickly connect and query. But how to query? With difficult SQL phrases? No, there is a much easier way, here you can do that through a simple web interface. In the search form, you can put the request, click the "Submit" button and delight yourself at the output of all matching information :-)

Download & Screenshots

The latest release is Version 0.2, you can download it here.
To have a look at the web interface you can go here (Screenshot #1) and/or here (Screenshot #2)

Features

storemp3 supports the following features:

All information from the id3tag is stored in the db, artist, title, album, ..., and even length, quality and the copyright flag. The perl module mpeg-mp3Info is used. Also the database handling uses perl modules, so the code is easy to adapt.
The location of the database is independent from the uses, who sets up his data, so e.g. more uses can share one database, if it is reachable from each user.
The web interface allows a quick reference to the data stored in the DB. Just type in the search string and all data found is printed.
Furthermore the web interface is independent from any special location, only access to the db must be possible.
The webinterface has got three colums, in the middle there's the already mentioned query form, on the left side there's a listing of all CDs and artists in the database. On the right side you will find the listing of all albums. So a quick lookup to any artist or album is possible.
As of version 0.2 you can also delete information from the database. Just specify your criteria as if you would search for the information, press the submit button and check the results. If you're content with the entries that have been found, repeat the same search with the "Delete" radio button checked. If you press the Submit button now, those rows that match your query are deleted, i.e. those that you found in your search before.

Requirements

To run this program in full featured mode, you will need the following programs:

Perl, the mighty perl and the modules for mysql and MP3Info, available at http://www.cpan.org.
A MySQL server that may be located anywhere on the network (you only need to have access to that database). There you have to create a database and a table in it.
A Web-Server, also somewhere on the net, or perhaps on localhost. The webserver must support php3, because the interface is written in that language.
MP3s ;-)

Installation

First make sure the required software is installed (at least the perl modules) and the mysql server is running.

Download storemp3 here.
To untar and unzip it, type
tar xvfz storemp3-XXX.tar.gz (replace XXX by the version)
Change to folder storemp3-XXX
cd storemp3-XXX
Have a look in the INSTALL, and change the values for host, user, password and database in the mentioned files.
Call the ./install script (see INSTALL file)
Optional: Move folder web/ whereever you want. When you want to use it, make sure the right permissions are set and the www-daemon can read them.

Usage

Example: You want to store a whole cd full of mp3s in your database.

The Installation was successful, now put your CD in the cdrom drive and type storemp3 /cdrom "my_first_mp3cdrom".

Bugs

Bugs ... perhaps, perhaps not, when you find one please email me. When you managed to fit it, send the patch :-)
Please report suggestions and bugs to

Joachim Wieland joe@mcknight.de
Sebastian Gunreben seb@gunis.de

Have fun with storemp3,
Joachim
Sebastian

Sebastian Gunreben, Jan 14th, 2000
updated: Joachim Wieland, Jun 14th, 2000