MusicDB

MusicDB is a series of tools for putting records of MP3s into a MySQL database and taking them out. It consists of four major parts:

Update.pl: Trawls a given directory for MP3s and puts them into a mysql database
Fetch.pl: Command line program to retrieve a selection of MP3s from the database as a list, or put the files themselves into a directory.
Also will retreive random lists of MP3s to a specified criteria up to a set file-size - for use, for example, for putting files onto an external device.
View.php: Web-based program to list MP3s, search though them with an easy-to-use drill-down interface and view data on them.
Fetch.pl: Web-based version of fetch.pl above, replacing random-file functionality with the exporting of Winamp/XMMS style .pls playlists of specific criteria.

Files:

MusicDB 1.0.1: MusicDB v1.0, all files.
MusicDB 1.0 Readme: The Readme file, containing requirements and installation details

2005-04-02: John Meadows submitted a couple of patches to the web-view functionality, which I've integrated and released as 1.0.1. Nothing apart from view.php has changed
2003-05-18: Released version 1.0 under the GPL.

CDDB file support?
The config stuff should probably be in a file somewhere which perl & php can both find and use.
fetch.pl: bitrate isn't implimented yet, neither is verbose properly.
fetch.pl: There probably should be a way to do exact-match criteria also.
view.php: The "contains" matches (instead of exact matches) facility is neither documented nor in the interface. (Replace "equals" with "like" in the resulting URL for all the matches which *contain* the requested data).
A dictionary of similer lines should be able to be defined, so that REM and R.E.M aren't differant in the DB.
The database keeps deleted files. Update should detect and remove these
Output of HTML "These are my MP3s" list.
view's output is horrible and kludgy as a result of a year's experience between writing the original code and kludging it into MusicDB.
Install is complicated, life should be easy.
Update should detect duplicates and warn the user. Note: Duplicates don't go into the database now, but it should tell the user.