Since I ran out of space on my HD, I keep most of my media files - ebooks, audio books, music - on DVDs. Soon enough it proved impossible to find anything, so I wrote a script that scans a DVD (or CD, or HD directory), and throws all the file names and paths in a MySQL database. Now I can search it with SQL for whatever, and get the exact location where the file is saved.
Metadata isn't included, but reading this thread I realize that it's important and I should add support for it.
I'm also in the process of writing a web application (with Rails) that'll give me a nice interface to search with, instead of raw SQL. It'll have the added benefit of my media library index being accessible from wherever I am, and by friends and family as well, so they can ask me to burn them files they like.
Anyway, this is all rather geeky and definitely not ready for prime time. I'm wondering though whether there's interest in such a tool so I'll put more time into it.
|