Another Library Question... But a different Type of Library ;)

Man of Honour
Soldato
Joined
2 Aug 2005
Posts
8,721
Location
Cleveland, Ohio, USA
My DVD collection is getting a bit out of hand. I have commercial DVDs, mini DVDs from my awful Sony DCR-DVD203, software DVDs and CDs, along with ages worth of backups of music, video, and general data. I'd like to implement a system of organization within the 800-or-so disks so that I can easily find the disk that contains the file I'm looking for.

Ideally it'd be a GUI app, perhaps linked to a MySQL or SQLite database for fast searches. I'd like it to make the data entry portion painless; stick the disk in, let it check the contents, write the proper metadata, and eject it so I can insert the next.

It's possible that something as simple as
find /cdrom/* >> big_nasty_list.txt could do most of the work. It'd be nice if it grabbed and recorded the disk's title as well. I could knock up a simple script that does that, but I imagine that with thousands or tens of thousands of lines in such a file grepping it would become a chore, hence the database. (I don't know squat about interfacing with databases in my own amateurish scripts).

Is there anything like this available? I'd prefer if it ran on Linux, but if you know of something excellent that runs on Windows, Mac, or even some other *NIX I'm all ears.

TIA! :)
 
Last edited:
Yeah, I'll have to generate a semi-arbitrary catalog system to locate the disks; essentially just assigning all the current disks a number based on current shelf position, then as new disks are added assigning each a new number in sequence. If anybody has any better ideas for this I'm all ears.
 
The are for the most part. Some of the archive/backup disks will contain different versions or iterations of the same file (i.e. xorg.conf will probably be so named on all backups). These aren't a huge issue since most backups are tarballs named for the date of the backup and the machine name of the source of the files. Additionally it's much less likely that I'd be looking for a file like that by name rather than the date.

EDIT: Please pardon me if I'm not making any sense. I haven't had a wink of sleep in 45 hours. :o

EDIT2: If the metadata, such as disk title, is insufficient for making a good catalog entry that really is my problem. It's nothing to be too concerned about. For instance if I pop in disk 3 of Lost's second season the title might be useless as will be the names of the files found on the disk. It wouldn't be a problem for me to just manually enter the data for that disk if nothing useful could be gleaned.
 
Last edited:
Back
Top Bottom