Solving the Home Library Problem?
zgrossbart asks: "My wife and I have about 3,500 books. We can't find anything. All the books are in random order. We want to find a solution for organizing our books. We have a barcode scanner, but I'm not sure the best way to use it. I want a solution that is easy to maintain going forward and makes books easy to find. I also want the data in an open format. I'm think about using MySQL right now, but I'm open to other suggestions. What software do other people use to organize their home libraries?"
If you've got a Mac (a big IF, I know), Delicious Library is the way to go. I've not seen its equal for Mac or PC. Barcode scanning (I use a modified USB CueCat), auto-querying for book covers and other information, borrowers, and so forth. Works for books, CDs, video games, DVDs, whatever. Worth every penny!
There is quite a large amount of open-source software available for library management. A full-blown ILS might be overkill for a personal collection, but I'd suggest checking out Koha and the listings at OSS4Lib.
My wife's a librarian, and she would laugh at the idea of using LoC numbers for a collection this small. Dewey's far simpler to figure out mentally for a collection that isn't the size of your local state university's. Heck, for a collection this size, you could go with the standard used book store layout. Just use general catagories and label the shelves so you know what they are. History (maybe break down into Ancient, European, American, etc. if you have a lot of history books), Religion, Science, Math, Art, etc. Fiction could be seperated into genres like Mystery, Fantasy, and Romance, or just organized alphabetically. The beauty is, you probably already know where these books should be catagorized, and you could probably do it all in the span of a few hours. Trying to do anything else, including assigning Dewey call numbers, is going to take a lot more time and effort for not much more benefit.
Here is the link: http://www.librarything.com/. This will help you with the cataloging of the books. As far as organizing, hrmmm, why not organize by color - that's how some women I know would do it :D
Closed source but for The Apple platform
http://www.delicious-monster.com/
It does everything for you. It works with either a scanner or you cna manually enter numbers.
The big solution though is physical sorting of the books. You have to keep them in place and return them to that place, being as anal as your old high school librarian about where the books/dvd's/etc are returned to.
i thought once I was found, but it was only a dream.
Please consider joining Bibliophile on sourceforge, which is a collection of a lot of the other open source literature management software. The effort is fairly informal, but we'd like to share tools for importing, exporting, and cross-site searching.
(FWIW: I'm involved with refbase)
On the Macintosh there is a program called Delicious Library that lets you use your iSight web cam to read in the bar codes. It then looks up the product at Amazon and stores it in your "library." You could scan in all your books (and movies and CD's) and sort them by Author or my Title to see which you like best. Then file them accordingly. It gets the book cover off the web too and gives you a virtual book shelf. The software also lets you check-out the book and track that activity. http://www.delicious-monster.com/ This program pretty much rules.
-Well, it may not take a Rocket Scientist to figure this stuff out, but I figure it can't hurt