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)
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.
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 ;-)
First make sure the required software is installed (at least the perl modules) and the mysql server is running.
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 ... 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 firstname.lastname@example.org
Sebastian Gunreben email@example.com
Have fun with storemp3,
Sebastian Gunreben, Jan 14th, 2000
updated: Joachim Wieland, Jun 14th, 2000