Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Cd's and mayhem

by mrbbq (Sexton)
on Jan 26, 2006 at 00:26 UTC ( [id://525614]=perlquestion: print w/replies, xml ) Need Help??

mrbbq has asked for the wisdom of the Perl Monks concerning the following question:

Hey Monks!
I have a bit of a situation and I am not sure how to approach it. I work for a development company and over the years we have had many things get archived to cd. So needless to say I have 1000's of cd's with data on them that developers occasionaly want. I would like a PERL script that simply recursivly reads the cd..listing all the directories and files in those directories....then write it to an mysql db. so at the end I can have a web app that developers can use to see whats on these cd's without having to load 50 cd's up at a time before they find what they are looking for. What would be the best PERL module to get this done as far as a directory and file listing of the cd?

Thanks!

Replies are listed 'Best First'.
Re: Cd's and mayhem
by pboin (Deacon) on Jan 26, 2006 at 00:55 UTC

    You didn't specifically say if you wanted to write this for fun or not, but what you're looking for exists already. You probably want to search for 'media catalog' or something along those lines.

    Here's what I use: GTKtalog.

    Just out of curiosity, how can you have 1000s of CDs and not have a catalog yet? What do you do to find information now?

Re: Cd's and mayhem
by Aristotle (Chancellor) on Jan 26, 2006 at 00:28 UTC

    File::Find? Already included with your copy of Perl.

    Makeshifts last the longest.

Re: Cd's and mayhem
by bluto (Curate) on Jan 26, 2006 at 15:38 UTC
    CD's are no way to handle that much data (e.g. 1 terabyte == ~1800 CDs) especially if you care about the data at all. I bet it will be a nightmare to catalog, maintain and recatalog this mess over the long run.

    Since you need to read them all anyway to catalog them (hopefully you have a jukebox), if at all possible, I'd suggest you buy a few capacity disk drives or a small disk-tape HSM system and keep the data there where users can get to it directly, without intervention. If your company has backup system that allows archiving (e.g. Tivoli), that may be another solution. FWIW, it is also much easier to make backup copies of data once it is on disk/tape. Another poor man's "solution": move the data to DVDs and catalog those instead.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://525614]
Approved by Old_Gray_Bear
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (7)
As of 2024-04-23 16:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found