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?"

Comments

BookCrossing

[Pete (big-pete)]

If you love something, set it free!

-- Pete.

Re:BookCrossing

[the grace of R'hllor]

Soooo many books that are probably being tossed in the garbage at McDonalds, I want to scream.

Well, I work at a Helpdesk, so me wanting to scream is nothing special, but still.

Anyway, the idea of keeping your books is that, if you desire something to read, you can reach into a shelf and there you will find treasure. As well as being able to look upon a story with either new insights into the story (multi-volume fantasy epics like Steven Erikson's, frex) or new insights into yourself.

That's exactly what I'm doing!

[RhettR]

I'm actually working on a project that EXACTLY fits your problem. Please check it out at homelibrary at sourceforge. I've only just started the project, it's not very easy to install right now, and there are a few bugs, but I started it with the exact problem in mind.

Use shelves.

[david.given]

And put the books in alphabetical order.

It's as easy as that. I have about that many, and I can always find things. My mother has about twice as many, and she can always find things. You don't need high-tech solutions, all you need is a certain level of self-discipline.

High-tech solutions are also very brittle. If you have to tell the system whenever you take a book off the shelf or put it back on, then you'll lose books, because at some point you will forget, and the system will have an incorrect view of where the book is. Alphabetical ordering doesn't suffer from this nearly as much.

Plus: alphabetical ordering lets you browse. I don't know about you, but I don't want to figure out what book I want to read next by looking at a database. I want to do it by looking at the shelves, and taking them down, flipping through, looking at the cover, putting them back, etc. That's what books are all about. This is your home, not a warehouse...

Re:Why software? - insurance

[From A Far Away Land]

The only advantage I can think of is for insurance purposes. You can backup the file offsite, and keep a list of your library to be replaced in case of fire or flood. A simpler way would be to take high re pictures of your bookshelves, which is what I did with my CD collection.

Really the best way is by author and then google the title or author when doing a search on a subject in a book he thinks he might have on his shelves. Then just find it by the author.

Bits or bytes?

[oren]

There are a lot of replies about what software to use to track the books on a PC. That's cool and all, but it is very little help when you have to find a book on the shelves. I happen to own about 1700 books - roughly half the number you have. I think people underestimate the magnitude of the task - assume roughly 1m shelves, 3500 books of 2cm each require 70 shelves - that's over a dozen packed bookcases!

To keep things sane, I added a colored sticker (yellow in my case) to the spine of each book, marked with the first letters of the author's first and last name. Actually I cheat a bit, there are a very small number of categories I use - cookbooks, references - where I put a category icon instead. I put the books on the shelves ordered by the marker. This is loose enough that I don't have to think too much when returning a book to the library, but tight enough I can easily find anything I want. Another side benefit is that when I visit old friends (or mothers :-), my books immediately stick out amongst the pile of books in their own sizable library.