Slashdot Mirror
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 love something, set it free!
-- Pete.
Monochrome - Probably the UK's largest internet BBS
Dear Mr. Guy Montag,
It has come to our attention that you have a surplus of books stored at your residence.
We have already dispatched firemen to alleviate you of this horrible affliction--fire trucks will be there within the hour. For you see, special-interest groups and other "minorities" objected to books that offended them. As a result, books all began to look the same, as writers tried to avoid offending anybody. This isn't enough, however, and society as a whole decided to simply burn books rather than permit conflicting opinions.
There are other unpleasantries that books cause but there is no need for me to go that far into detail.
As you can see, your search for a digital Dewey decimal system is unneeded. And it is quite peculiar that anyone should have as many books as you do. Do not worry, though, we are a free public service!
Thank you again in your cooperation and trust that our services will be a valuable solution to your growing literary problem.
Sincerely,
Karl Rove Senior Advisor & Chief Political Advisor The Bush Administration
My work here is dung.
I bootlegged a copy of AV Cataloger and liked it so much that I bought it. I recommend it to all, but it is a Windows-based program.
/. readers don't like closed-source Windows-only software, so I'd welcome an F/OSS solution just like this. Until then, this is a worthy purchase.
I'm sure you can write your own, but AV Cataloger hits all the sites to gain information -- even Amazon for books. It also helps to keep track of what you loan to people (my mother is the worst thief my latest report shows!).
I know
I think you lost most of the slashdotters when you started with "My Wife..." People are googling this "wife" to see what they can find out about the phenomenon. Once that dies down, then maybe you'll get some results.
Seriously, the Dewey Decimal System has always worked for me. Unless you're running an actual "Go-ahead-and-check-stuff-out" library out of your home, the barcodes and MySQL seem like total overkill.
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!
Pick one of these methods of classification.
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.
Athletic Scholarships to universities make as much sense as academic scholarships to sports teams.
Crazy High Tech Solutions pale in comparison to old - school ones. Divide your book cases up Fiction and Non and categorize from there. Put the books most commonly read on easy to reach shelves. My parents have easily that many and don't run into any problems looking for the book they want to read. It is enough to have a vague idea of where the book is, History of Computing - Non Fiction around shelf 3 and call it a day. How do people find books at a bookstore anyhow?
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.
Do as the librarians do: divide the books into major subjects and then alphabetize by author. If you need to search by something else, Google is your cross-reference.
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.
We can't find anything. All the books are in random order.
Have a catalogue on your computer isn't going to tidy up and organise your bookshelf. SQL queries don't work on shelves. Unfortunately.
http://twitter.com/onion2k
Unless you have a massive reference collection or are checking books out to friends, why bother with software? The solution to your problem is physical organization. Even if you can't have all the books together, you could organize them using LOC or Dewey, or something and label the locations.
//e. Printed little labels and everything. Why? Because I was 12 and had time to burn... I never looked at it again.
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
Have a couple of kids and you'll find that trivial stuff like this will be the least of your concerns - most of your possessions will be in random places.
"We want to find a solution for organizing our books. I also want the data in an open format. "
Dewey decimal system? Maybe one of you should pick up a degree in library science.
"We have a barcode scanner, but I'm not sure the best way to use it.
Aim the red light (the "la-ser") at the "zebra stripes" and wait until you hear a beep.
"What software do other people use to organize their home libraries?"
Hell, I read books to get a break from computers. I think if I had that many books I'd donate most of them to the local library. I know I don't have time to reread 3,500 books - there's millions more out there I haven't read yet!
Anything else I can help you with today?
Shelf 1: Romance Novels
Shelf 2: Thermodynamics Textbooks
With all that steam, you can also use that room as a sauna!
--
Nanoscale Woodworking
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...
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.
Oh You POS
I'm going to have to echo the "why do you need software?" calls.
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
...and that's all there is to it.
I use Readerware.
Spent a couple of evenings scanning in my books, it then went and got all the details from Amazon etc and I ended up with a nice database of all the books.
It was a bit slack on some of the old and obscure stuff - but if it's in an online bookstore, it will usually pick it up.
I haven't tried it for CDs or DVDs - I use DVD Profiler for that.
HTH
T
If a square is really a rhombus, why aren't all triangles purple?
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!
:-), my books immediately stick out amongst the pile of books in their own sizable library.
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
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
Just use librarything.com.
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!
If you have a specialty library, it can be completely useless -- imagine going into a library where every book was filed under '005' (computer programming). If you don't have a general library, Dewey isn't going to be as useful for sorting -- you'll want to look into a specialty thesaurus or ontology for your holdings.
As generalized libraries go, if there's a chance of moving it to a database, I personally prefer UDC, 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)
Build it, and they will come^Hplain.
Outsource this task to your local library by donating all but your frequently needed reference books there.
Then you can easily browse the shelves, use a computerized search search system, or even ask a live person for help. You'll even been able to find books you didn't even own before. All for free!
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)
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.
Tiller's Rule: Never use a word in written form that you've only heard and never read. You will end up looking foolish.
That's a total no-brainer.
Delicious Library. Period. No other Library programm or solution comes even close. It's the companies only product, sells for 40$ and it's a programm that justifies buying a Mac just for the purpose of running it. It's that good.
It has everything you could wish for and loads more. Among the most notable features are bot's that spider the web (amazon, etc.) for meta info on your books based on the barcode (including grabbing cover-pictures), option to use a webcam as barcode scanner and exports to data formats of your choice.
Really, looking any further is pointless. DL+Mac Mini+Barcode Reader or Webcam will take you farther than any other solution you could even dream of.
We suffer more in our imagination than in reality. - Seneca
When I bought Delicious Library, I wound up spending all night scanning in all my books.
Note: some items trigger easter eggs when you add them to your library.
September 2011: Looking for Cocoa/iOS work in Boston area Cocoa Programmer Quincy, MA
It IS wrong to throw away anything that still has a useful life.
Yeah but it's Piers Anthony...what else are you going to do with it?
Separate the books into technical and fiction. Then group the fiction books by author. Group the technical books by subject. Don't make it difficult or cumbersome. Trying to maintain a database of books is not going to let you find them easier. Using barcode readers and other technical solutions will just take more effort and in the end you will still need to organize your books as above.
I'm a librarian, and believe me you're making this harder than it needs to be. Barcode scanning is great... if you want to check material in and out. LOC/Dewey organization is great... if you can spend several minutes per book assigning catalog info and creating your own cutters. You're dealing with a home collection; your main concerns are shelf space and a functional order. This may sound radical, but forget subject headings; it's unnecessary for something this size. Just get them in alphabetical order, either by title or author last name. At most, you can separate them into 2 or three different size categories for easy shelving --oversize, "regular", and etc (unusually thin or loose pamphlet-type material, books w/ CD-R cases or other packages.) For my home collection, size is the primary sorting category -- it's easier to move around when your stacks are pyramid-shaped. It's amazing how technology can be not only sophisticated, effective, and simple... but that sometimes it doesn't even need electricity. Go figure.
I manage my books and CD's with Readerware and a portable scanner with a USB interface. Very cool.
Doug Jensen
Delicious Library is an excellent OSX application for organizing your books, music, games, and movies. It has support for scanning barcodes (even with a web cam).
I use it, myself, and it's extremely useful.
Up, Up, Down, Down, Left, Right, Left, Right, B, A, START
From the their self-description:
It is intended to manage a small library or documentation center: at 3500 books, you are still considered a pretty small documentation center... But it could ease a lot the management of those books, the friends borowing, etc.
They have a lot of success-story. My librarian wife finded it nice when I showed it to her. Even though she refuse to keep woking at home organizing our books. Damn!
Of course, to really help keeping track of the books, you will need a good physical organisation too. But since Koha can talk Z3950, it may be possible to obtain the classification professionnaly done by big libraries: making Dewey or LC classification is _hard_. Librarian don't usually have master degree for nothing... So I would suggest refraining from going that work yourself ; pick a simple organization, since 3500 books is not that big, when you think about it and compare with _real_ libraries...
Good luck!
Announcer: "Never before in the history of motion pictures has there been a screen presence so commanding ... so powerful ... so deadly ... He's CONAN THE LIBRARIAN!"
... THE DEWEY DECIMAL SYSTEM?!"
... Tonight, only on U."
Library Patron: "Can you tell me where I could find a book on astronomy?"
Conan: "Don't you know
Announcer: "Conan the Librarian..."
Library Patron: "I'm sorry, these books are a little overdue..."
Conan: "RAR!"
**Conan cuts library patron in half with enormous 2-handed sword**
Announcer: "Conan the Librarian
With the first link, the chain is forged.
I'd've stopped after "organize your books", but anyway ...
--
Slow down cowboy - it's been 12 days, 4 hours, 6 minutes and 4 seconds since your last post.
.. paranoid crackpot leftover from the days of Amiga.
If you already have 3500 books, you're probably a collector, not a "tosser" at heart. You need to consider how your system will accommodate future expansion to possibly tens of thousands of books. In no particular order:
Here are a couple specific strategies that have helped me and my wife:
CRAWFORD, TEXAS -- A tragic fire on Sunday destroyed the personal library of President George W. Bush. Both of his books have been lost.
A presidential spokesman said the president was devastated, as he had not finished coloring the second one.
Haida Manga
...it isn't my congress. :-)
Seriously though, LoC doesn't work too well if you live in the rest of the world.
You are right in some ways: there are http://www.snopes.com/katrina/charity/library.asp institutions that really would appreciate secondhand books: hospitals, Salvation Army, schools, homes for the elderly. Better contact them first before showing up with several cubic meters of Louis Lamour pockets though :)
All those moments will be lost in time, like tears in rain. Time to die.
Library of Congress is better--the call number for each book is unique. With Dewey, you have a subject heading, and all the books within that subject are basically unordered, as far as the system goes. If you can't find the author of a book, then, what do you go by? Just the title?
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.
Books don't fail to boot.
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?
This space for rent.
Buying Dead-tree books is fucking stupid ,it harms nature
Nope. Buying Dead-tree books is good for the environment. Just think of all the CO2 that tree soaked up from the atmosphere and has now sequestered (as cellulose) in that book.
Help reduce greenhouse gases, buy and keep dead-tree editions.
-- Alastair
>I believe this has already been taken care of... It's called the Dewey Decimal System.
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
O~ Him that studies revenge keeps his own wounds green. -- Francis Bacon
Do these people know how to use a computer???
Directions for How to Use a Bar Code Scanner:
Tips/Warnings