Solving the Home Library Problem? 579
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?"
The Dewey Decimal System (Score:4, Insightful)
Three answers (Score:2, Insightful)
i) LoC classification.
ii) Dewey-decimal.
iii) Alphabetised by author.
I'd recommend (i).
Given the small number of fields (Author, Title, Year, Publisher, LoC shelfmark), you can store the information in a flat text file.
Start with Fiction Vs. Non (Score:3, Insightful)
easy (Score:5, Insightful)
Finding books.. (Score:5, Insightful)
Have a catalogue on your computer isn't going to tidy up and organise your bookshelf. SQL queries don't work on shelves. Unfortunately.
Re:Three answers (Score:5, Insightful)
There are libraries in the world with hundreds of thousands of books, and you can walk right in and find a book you want. The technical aspects of this are just pure unnecessary geekery.
Why software? (Score:5, Insightful)
Having to update software everytime you move a book or add a book is just one additional step that doesn't seem to add any value.
When I was 12 I put all my books into PFS:File on an Apple
software? we dont need no steenkin software (Score:3, Insightful)
Fiction vs Nonfiction
Break fiction down into scifi, fantasy, historical, or whatever else applies
Break nonficiton into computers, biography, history, math, science, etc
Then alphabetize categories by author, and label your shelves.
Use some cardboard to make book-sized dividers and write A, B, C, D, etc on them
Re:The Dewey Decimal System (Score:5, Insightful)
Who needs scanners and bar codes? Libraries have kept much bigger book collections organized for centuries with less tech than that.
Re:Use shelves. (Score:3, Insightful)
This problem really is essentially the same as organizing paper files. The key thing is to decide on a classification scheme that makes sense to you, and the to go with that. The only software you really need is what came pre-installed inside your skull.
Re:The Dewey Decimal System (Score:5, Insightful)
The problem with using the Dewey Decimal system in a residence is that home users may not have room to line up books by author. Books come in multiple sizes, but an individual shelf only holds one [maximum] size of book - and is inefficient with anything smaller. Thus, most home book collections are organized by available space.
People without more shelf space than they can use are much better off just labeling everything where it sits, and returning books to the hole from which they came. The book information can go into a database, and you can search/browse them that way. Some clever software even steals book covers from amazon so you don't have to do it manually.
My final suggestion is to put a barcode on each shelf. You could put one on the bookshelf too, but that's redundant. Scan the shelf, then scan all the books on the shelf. You can accomplish all this with a very simple untethered barcode reader (read: inexpensive.) When you bring the reader back and dump the data, all you have to do is maintain a teensy bit of state (remember the bookshelf info from the scan) and then just stick records in the db as you go. Each book will be recorded as being in the last location scanned. When you get a new location, overwrite the old variables, and keep going. When you get to the end of the data, you go home a winner. Snarf the data out of amazon or similar using one of the many APIs available (up to and including the official one) and you're done.
Use librarything.com (Score:3, Insightful)
Make a free trial account, enter a few ISBNs, and once you're hooked shell out the few dollars for a full account and get rolling.
Tim that author is adding lots of data import filters and tagging options and other very geeky features, and an actual librarian has joined the project. (I know, I know: it's amazing seeing a non-commercial software service with a real-live subject matter expert! Just goes to show the author's not a real geek: he admitted that someone else's specialized knowledge might not be replaced by his own prejudices and SWAGs.)
Go, librarything, go!
Dewey is for general libraries (Score:5, Insightful)
As generalized libraries go, if there's a chance of moving it to a database, I personally prefer UDC [wikipedia.org], due to the way in which is handles sub-topics. (if you had something on the History of British Railroads -- where does it get filed in Dewey? History, European Countries, or Transportation Infrastructure? UDC maintains each of the facets, without needing 3 books of indexing instructions)
Re:The Dewey Decimal System (Score:3, Insightful)
The Dewey Decimal system works well for "I have a general idea of the subject I want, so let me browse around and find a book that looks interesting", but if you're going to do all your searching at a computer instead of "in the stacks", and storage efficiency is a concern, the Library of Congress system may be a better choice.
Re:Finding books.. (Score:5, Insightful)
Taking and inventory of what you've got, and recording that data would only mask the symptoms of the underlying problem. The real solution is to organize the books, and eliminate the chaotic random scheme you have now.
With your current setup, your inventory program would be completely dependant on being updated whenever a book is placed on a shelf, which takes discipline for the life of the application.
Taking the time now to organize the shelves will greatly reduce the amount of work down the road, as long as you put your books back where you found them.
For all you 'Just organize the shelves' folks... (Score:5, Insightful)
How will organizing the shelves help when you're in the middle of a bookstore and are wondering if you already own a certain book? I can't remember all several thousand books I own - having a digital reference on my PDA is invaluable.
Re:Throwing it ALL away... (Score:4, Insightful)
Yeah but it's Piers Anthony...what else are you going to do with it?
Why make this harder than it should be? (Score:5, Insightful)
Re:BookCrossing (Score:5, Insightful)
Gak! (Score:4, Insightful)
Still, your personal system depends largely on how you usually remember your books. Do you usually say 'I had a green book about so high and maybe four or five hundred pages long'? If so, you might find it most intuitive to have your books physically ordered by appearance and use a database to browse by subject or author. Or do you usually do research on a particular subject? Then going by the Library of Congress system would probably be best. Or if you binge on particular authors, you might prefer categorizing authors by field and then arranging books by author.
Disclaimer: I am a librarian, and I work in a university library using LoC call numbers.
Re:Scan them all and use google desktop (Score:2, Insightful)
Books don't require batteries.
Books are often more compact than their electronic equivalent.
Books can withstand massive g-forces and falls from great heights.
Properly cared for books can last hundreds to thousands of years.
Now why again should I go exclusively digital?
Insightful? Ha! Snide more like (Score:2, Insightful)
Oh, the joys of being at the top and all those desperate modders just itching to dump their mod points before they're gone. Back to topic, no-one's going to use dewey decimal outside of an institutional setting, that's just dumb.
How about categorizing by subject and author? Put all the books on math & physics on one shelf, then alphabetize that shelf by author. Take all the romance novels and put them in the guest bedroom, and do the guests a favor and put all the ones with explicit sex scenes in one place for easy browsing.
Jon
Re:Government Solution! (Score:2, Insightful)
"Convicted"? It doesn't have to be illegal to be morally reprehensible.
So, "left winger" is defined as "anybody who thinks Karl Rove is despicable"?
Kay.
The guy is fucking Darth Vader. I am astonished at his political acumen...and his utter lack of integrity. This guy works for the party who alleges to command the moral high ground? This guy thinks "family values" are "how much can I get for my granny at auction?"