Slashdot Mirror
Ask Slashdot: High-Tech Ways To Manage a Home Library?
DeptofDepartments writes "With Kindles and ebooks on everyone's lips (sc. hands) nowadays, this might come as a surprise to some, but besides being a techie, I have also amassed quite a collection of actual books (mostly hardcover and first editions) in my personal library. I have always been reluctant to lend them out and the collection has grown so large now that it has become difficult to keep track of all of them. This is why I am looking for a modern solution to implement some professional-yet-still-home-sized library management. Ideally, this should include some cool features like RFID tags or NFC for keeping track of the books, finding and checking them out quickly, if I decide to lend one." For more on what DeptofDepartments is looking for, read on below.
DeptofDepartments continues: "One problem seems to be the short lifetime of RFID tags (only 5-10 years). Given that many books will probably only be read or checked out once or twice in this period at best, the administrative effort seems very large. I have also been largely unsuccessful in finding tags or solutions that go beyond the cheap 5 to 20 item 'starter kits', yet still remain affordable and below the industrial scale.
Also, what would be suitable and affordable readers/writers for the tags in this context?
Finally, as many of the books are old folios or fairly precious first editions, everything must be non-destructive and should be removable without damage to the books if need be.
(Note: Scanning ISBNs with a hand-held barcode scanner is not an option, as many books are old (pre-ISBN) or special editions).
Software-wise, I would like to have a nice and modern-looking, easy-to-use software that can interface with the hardware side as described above. I do not necessarily need multi-user or networking capabilities at this point.
I hope the CSI (Combined Slashdot Intelligence) has some helpful ideas and pointers for me on this!"
Also, what would be suitable and affordable readers/writers for the tags in this context?
Finally, as many of the books are old folios or fairly precious first editions, everything must be non-destructive and should be removable without damage to the books if need be.
(Note: Scanning ISBNs with a hand-held barcode scanner is not an option, as many books are old (pre-ISBN) or special editions).
Software-wise, I would like to have a nice and modern-looking, easy-to-use software that can interface with the hardware side as described above. I do not necessarily need multi-user or networking capabilities at this point.
I hope the CSI (Combined Slashdot Intelligence) has some helpful ideas and pointers for me on this!"
http://en.wikipedia.org/wiki/Book
Deep & Simple
You have too much shit, Dude.
... to get a Cray super computer to track it high tech style?
Organize your books using Dewey, make or buy slip covers, and while you are physically labelling them enter information in a card catalogue database.
If you're going to keep books as a labour of love you can make time to catalogue them.
I have no experience in this area, so this is purely how I would approach the problem from a blank slate.
I would go with good ol` fashion "bunch o` lines" bar codes. Easy to make yourself, should be easy to attach to a book (or not, maybe just have it loose between the cover and first page), lots of cheap readers and most just emulate a keyboard so easy to interface with.
From there I'd probably throw together a little home brew. What you are asking for does not really sound complicated, the software side sounds like a weekend project for just the basic requirements. Even if you just do it as a basic web app. Be sure to add a title based search for if the barcode gets lost, so the bar code just becomes a convinience and not a requirement to use,
Put them in alphabetical order. Use a ledger to record lending.
You're welcome.
I would reccomend taking a polaroid of the person you are loaning the book to and then leaving the picture on the shelf in the place reserved for the book. Other viable database options include a chalkboard log of the Dewey Decimel numbers or scanning each book to a tape drive for safe keeping.
If only there was some kind of institution that did that actually lent book to people on a daily basis that you could take ideas from... oh wait there is!
Check your local library, the ones I've been to all use barcode scanners, if it's good enough for them it should be good enough for you.
buy an ebook reader...
Try Delicious Library. http://www.delicious-monster.com/
Simplest solution - use the ISBNs - plenty of bar code scanning apps exist to scan these in... For books without the ISBNs - create your own QR codes to catalog/scan them all...
legacy.audacious-software.com/products/books/
I've used this for years. Hold the book up to the camera to ID it. Easiest way to do this is via ISBN -- you can always create your own barcodes for the books that don't have them, and affix these somehow (I affix inside with acid-free glue, this may be sacrilegious to some). Otherwise, you can use an image recognition module. Contains complete check in/out functionality and is open source.
I've been thinking that there should be some way to add a plugin for Calibre that can do all of this too, but Books already does everything I want.
I don't use it (I'm not *that* organized), but this looks like a candidate.
http://www.delicious-monster.com
http://delicious-monster.com
I would get a barcode scanner, make/buy whatever software cataloging system you want as long as it takes text input and you'll be fine. Then you can easily print out a sheet with a bunch of barcodes and whatever other information you would like with each book (title/author/year/etc) and fold it over the top of the first page.
When you check out books, scan the barcode and put the code page in an "out" box. You can check the box physically to easily see which books are out if your software goes down. When you check books back in, just replace the foldover.
Cheap, easy (you could prob get ~10/print page depending on the information you want), physically redundant, and non-destructive. Sorry, I have no hints on SW, but you should be able to find some sort of catalog/inventory program without too much difficulty.
Do what I do: Buy some Ikea bookshelves and put them in alphabetical order by author.
K Man
If you're dealing with rare or valuable books, I'd forego RFID. The adhesive on security tape and RFID tags is somewhat acidic and ultimately destructive. You have to balance the desire for security with the desire not to harm the books. But any adhesive is somewhat destructive, by its very nature.
RFID equipment is also less than cheap. I think in small numbers, you're looking at about $0.60 per tag, and the equipment itself is a few hundred dollars for encoding and sensitizing/desensitizing.
I work in a library, and these are discussions we have regarding rare and collectible books.
----------
Something cleverI have about 6000 books. Some of them are quite old (passing the century mark). Many of them (about 1400 that I know of) lack bar codes or ISBNs.
I've been down this road before.
After a few fancy tries, I got lazy and loaded an android app called Book Catalog on an old phone. It does everything I need, though I wish it had a way of syncing databases across multiple devices. I manually enter those I can't scan. I don't bother with bar codes. I identify by name, author, date, and location (shelf, room). I keep the books in order on the shelves. I pay attention when re-shelving them. A little bit of self discipline goes a LONG way.
In all honesty I haven't got everything catalogged yet, but I'm in the...checking...2788 range. I enter anything new I pick up (both so I don't get further behind and to avoid duplication) and scan/enter a few books at a time whenever I'm in an OCD mood.
QR codes? RIFD and accept the replacement cycle?
Pretty much any solution to your problem is going to require: effort, money, or the decline of value through mild damage (stickers, etc on the covers).
Your best bet is simply to stick with option A: effort. Catalog them yourself, maybe include links to amazon for the synopsis, let friends peruse that instead and track when you lend out books yourself. Keeps your books in better condition, and costs you nothing but time and energy to do all that and find a couple of good programs to do your cataloging and lending management.
Otherwise kiss the value of your books goodbye and just slap QR codes all over them. Bonus you can get phone apps to read them or just use your webcam.
Only five comments and already the theme is either, you have too much stuff or keep it simply and use a pencil and paper catalog. So, allow me to posit another scenario.
I'm also very interested in a similar solution for keeping track of paper file folders in a small business. Despite careful effort to control file storage and check in/out of files some files still fall through the cracks or aren't properly logged. This can cause some files to go "missing" for a few days or even weeks.
It would be highly desirable to have a system, as the original poster requested, that could not only manage the check ins and outs of files, but also utilize RFID or some other technology that would permit us to locate misplaced files. A system that, perhaps using triangulation, could show us where the file is presently physically located would be fantastic, but wandering the office with a hand held RFID "detector" to locate the file would work well too.
Any ideas for prebuilt low cost solutions?
Barcodes are cheap and easy to print out on Avery labels. Barcode readers are cheap and easy to use. Hell, there was a time when a company *gave away* barcode readers. You may remember Cuecat. I still have mine.
And now that you're turning up your nose at barcodes, consider that large libraries have been using barcodes for decades now. They are proven technology.
As for organization, you can look to the Library of Congress for that. The Library of Congress indexing system is a proven system for small and large libraries. Indeed, the LOC number is typically printed next to the ISBN on the copyright page.
Software? For a home sized library, a flat file database should be enough.
--
BMO
Physically arrange them on an aesthetic (binding style, size) basis. If you truly know your books, you can find them Gestalt-wise.
Index them as e-books (download from PG or PB). Helps with content-wise referencing, e-lending.
Set your phasers on "funky"!
A spreadsheet? Sure, you *could* get fancy and have barcode scanners, RFIDs, NFCs, and other acronyms that will cease to function in a few years. Or you could just write down the titles on a spreadsheet, and have a column for who borrowed it, and when. Eventually, you could even upgrade it to a real database with fancy front-end software and special iPad apps. But considering your past reluctance to lend your books in the first place, I'm guessing you won't be lending out more than one every week or two, or less frequently. The borrowing itself is not hard to keep track of.
As for arranging them on the shelves? Bookstores are designed for browsing purchases, and categorize by genre, author, series, age, price, etc. Public libraries are designed for finding content, and categorize by dewey decimal number (which itself is somewhat by genre, author, etc). Your home library can of course be whatever you want, even arranged by color or length, if it fits your needs.
If you lend out a book, never expect to get it back. It's the nature of it all.
I use Shelves for Android to keep track of all my Books, DVD, Games, what not.
It has functions for loaning out materials and uses the barcode scanner software you install on your phone or tablet device.
Shelves at Google Play
these days, most people already have a barcode reader in their pocket
As others have noted. Alpha by author. Or better yet, sorted by subject and then by author.
For lending -- old school low tech:
http://www.thinkgeek.com/product/e326/?srp=2
I have been using Delicious Library for 5 years and it is excellent. It seems to have been created with exactly home libraries in mind. BTW, no need for a scanner. It uses your webcam to pick up the barcode. Call me a fan. Delicious Library -Tayster
Perhaps Bill Adama had it right - give books to people, never lend them. Then you can't get upset if they never make it back to you.
Go the HC way and try out Koha http://www.koha.org maybe? Know i found virtualbox images for it when i was looking into it which makes it easy to see an actual install and play around with before trying to set it up properly. There are some other opensource ILS systems out there aswell. Havn't touched them personally yet though.
Simple, Calibre
I once used Readerware [http://www.readerware.com/index.php] to catalog all of my books. At the time, I had around 400. I found, however, that I was too lazy to keep track of the ones I lent to people. These days, I only lend the ones I don't mind never seeing again.
You can also use Google Books [http://books.google.com/googlebooks/mylibrary/] to keep track of your home library. Again, I have been too ADD to finish the entire catalog. I only keep track of the science books on there...
I have a
Did you know that for $1500, you can build your own book scanner power by a vacuum cleaner? It will harmlessly scan a 1000 page book in about 90 minutes. Scan your entire collection, and then just loan people the digital files.
http://www.theverge.com/2012/11/13/3639016/google-books-scanner-vacuum-diy
Wow, a polaroid? Really? Just let the out dated technology die.
[SARCASM]Yea, it's way better to use a phone or digital camera to take a picture, process it through Instagram or some other app, print it on your printer...[/SARCASM]
Where as with a Polaroid you point click and it spits out an Instagrammy paper print. Done.
Just because the technology is old doesn't mean that it is bad
Just because the technology is new doesn't mean that it is good.
Really!
Best way to add books is to type in the ISBN, then the website searches online databases, to include Amazon.
You can also add tags to your books, like fiction, non-fiction, read, not read, etc.
Every book I read this year gets a "2012" tag, so I'll always know how many books I read in a given year.
He who laughs last is at 300 baud.
Give them all to your local library. You'll get a free storage, indexing and retrieval system in the exchange.
Regards,
jcw
Just stick with the Dewey decimal system. It's worked since 1876.
Find a vault and put them in, make sure they're treated, to last hundreds of years. No, not because they'll gain some historical value, it's just that, the way the market is moving, it won't be long until buying licenses instead of the actual books will be standard practice. (Hint: the authors will get even less)
Then, download as many books as possible, legally or illegally and store them in Calibre, in as many formats as you can find (epub is just html, so, that should be enough). ;)
They'll last for decades unchanged.
You can browse form your sever anywhere in the world.
You can convert for any e-reader format.
You can move it from one place to another in your pocket, phone or tablet (don't know about Surface).
Backup is easy; if I were to imagine a hypothetical digital library like the one I mentioned above, I could probably squeeze in 22k books in just 27GB.
Um... an Excel spreadsheet with Title, Author, Loaned To, Loaned On, columns?
1) Donate all items to library
2) Get a library card
They will keep track of everything for you, and you can deduct the value of the items on your taxes
http://www.librarything.com/
If you're reluctant to lend them, don't. If you do lend, them, accept that you might not get them back. Technology is not the solution to this problem.
I want to delete my account but Slashdot doesn't allow it.
Yeah, geeks tend to measure their intelligence by how many books they own.
"if I decide to lend one"
I take that to mean you aren't already loaning them. I suspect you'll find you won't be loaning many, because who's going to look at your collection when they could look at the library, or since you'll have things potentially interesting to geeks, they'll be looking to buy their own so they can increase their apparent intelligence. Mostly, though, you're the only one who cares about your collection of books. Don't try to one-up your geeky friends in this very personal thing. They won't like it.
So, keep it simple. A pad of paper, in case you loan any. Because you won't be loaning many.
I have a lot of books, I also have ebooks, pdf files of all types. My solution is calibre - E-book management. Create a check-out column and just type in a persons name when you loan it out. To input a book, type the ISBN and it searches the interest for the information and a book cover picture.
Check it out!
I converted an old tape library with a bar code reader to use a grab-hand for lifting and a set of Ikea shelves for storage. It stores the books FOLI (First Out Last In) and uses a second hand to shove everything down to the end of the shelf. Bar codes on the spines and a stop-bar an inch from the end of the shelf and it knows where to get everything.
Only problem I'm having is the RABBIT protocol (Random Access Book Browsing InTerface). It runs a little slow.
While that is true, have you ever tried to catalog hundreds or thousands of barcoded books or movies with your phone? Waaaaaaaay too slow.
I use a CueCat, and queueing up the barcodes on the computer works as fast as I can swipe. (Usually about 1 per second.)
The only pain about my CueCat is that has a PS/2 connector, rather than USB. Still, it was free, and I nabbed about 10 of them back in the day.
Good suggestions!
For those books which lack a bar code on the jacket, make a book cover and apply the bar code to THAT. (Was a rite of passage every school year as a child that we'd make book covers for all our books. By ten-years-old, I was doing all my books unassisted. We just used paper grocery bags, but you could certainly use some kind of low-acid paper if you'd prefer.)
As for constructing a bar code, there's free bar-code software out there (I've used pbmupc). The basic format is a 1-digit type, a 5-digit manufacturer code, a 5-digit product code, and a check digit. Create a manufacturer code that's reserved for your non-UPC'd books (31337 would be cool, but I think it might already be taken), and then just use a sequence number to identify the individual books.
Lastly, have fun! It's certainly a more interesting project than writing a "hello world" program!
The software I use is done by a Dutch company called Collectorz (Yes, it sounds VERY reputable). It's one of the few bits of software I've genuinely felt worth purchasing for the value. It does pretty much everything you are looking at, cleanly and effectively. It allows you to export databases in a variety of formats, and has a matching app for android and apple products.
It does the classic things like search Amazon for books, either by ISBN or author/title, but it can also hit the Library of Congress as well as several other major national libaries (I know it does the UK as well as Canada). Multiple hits on a single ISBN/title let you select which you import in, and there's a wide selection of data tags you can use, as well as several user defined fields
One thing you may find useful is that the book assigns, in addition to everything else, a unique ID number to each book, which can be used in lieu of a barcode or more cumbersome ID method.
Sort the books by topic. If you have a lot of books on the same topic sort by subtopic.
Koha http://www.koha.org/ is an open-source library catalog.
It has circulation and database. Use barcodes or RFIDs on the books (the tip of extra cover is good).
Many real libraries use Koha for their library database and circulation.
YMMV
koha.org
very flexible, favourite with librarians.
I have a large collection, here is what I suggest:
-- Get a copy of Readerware (http://www.readerware.com/
-- Set Readerware's Auto-Catalog feature to Merge data from Amazon.com, Barnes & Noble, Library of Congress (long drop-down list, pick all you want).
-- Use your Android/iPhone to scan all ISBN bar codes into Readerware Auto-Catalog. It takes a couple steps, but is easily doable and saves a great deal of time.
-- Run Auto-Catalog. Most popular books are populated automatically, including dust-jacket image.
-- On a 1 " Post-It, write the full Library of Congress catalog number. Flip the block of Post-Its upside down, and write the number at the top edge (formerly the bottom edge). Stick the post it to the first page of the book, close to the spine, so that it is readable at the top of the book.
-- Organize your books by Library of Congress catalog number. It will be magic, how your library takes shape, with all books on similar topics grouped together.
-- Readerware allows you to note location (so if you need to spread your library over a couple rooms, you know exactly where your book is). It also allows you to track lending, and pretty much anything else you want to track about your books.
Good Luck
How many do you think you are going to lend out? To how many people? Be realistic. Making a card per person and write in the book they lend and when might be easier.
On a card you just write the name of the person. Then when lending out a book, write down the name of the book, the author and the date. Then when they bring it back, fill that out.
I would go for a per-person approach and not a per book approach as libraries do it, because you will most likely have less people then books.
Having it on paper and not electronically will make it easier to use for the next 50 to 100 years. No real reason to update. Instead of cards, a paper notebook would do the trick as well.
You can even use it for other members in the family to keep record who read what and when. Nice to look at in many years time.
I would not go with anything electronic. Just make sure that you know what kind of notebook you want, need and how many columns you need. An extra is that other people will be able to use it when you are no longer alive. That way they can get the books back (if they want to) without any knowledge of the way databases work at that time.
Don't fight for your country, if your country does not fight for you.
They are getting expensive but USB CueCats do exist. They work the same way as the PS/2, only it's seen as a USB keyboard.
these days, most people already have a barcode reader in their pocket
Except many of those are pretty crappy for standard 2d barcodes. My phone (and others I've played with) do great for QR codes and a few other "newer" types of barcodes, but are painfully slow and difficult to get to scan older barcodes.
Our library has a phone-based checkout system, where I can use their app on my phone to scan book barcodes for "quick" checkout. But it turns out that the minute of fiddling with the distance/lighting/angle to scan the barcode just isn't worth it. I've had the same trouble with an inventory-tracking app I've been working on for the workplace. Phone cameras are just pretty poor at scanning/parsing most 2d barcode stickers.
"(Note: Scanning ISBNs with a hand-held barcode scanner is not an option, as many books are old (pre-ISBN) or special editions)."
I recently scanned all my books (~250) into a Goodreads account using an Android app. Only a couple of dozen or so didn't have ISBNs. And for those I just typed in the name and it was able to find the book. I believe there is also an option for adding a book if Goodreads can't find it.
Coder's Stone: The programming language quick ref for iPad
You know, you could take a picture using an iDevice, and then use airprint to send it to your printer, walk over and get the print out long before a polaroid would finish developing.
You think your iDevice and printer can print a multimegapixel color page in under 90 seconds? If it can; at what cost?
A $100 Polaroid camera can/could(since the 1970's) output a multimegapixel color print in 90 seconds or less. (The print is actually output in under 5 seconds, but it takes up to 90 seconds for the image to fully develop.)
Where's my cane? I need to beat a clue into this troll's ass.
I did the inventory of my 500+ book collection here and while it took a few days, the upkeep is minimal, and gcstar allows me to also keep track of people I lend the book to. The interface is awful, but it does connect to Amazon and so on to get book details, including cover pictures, if you have an ISBN. If you don't, then it's likely that Amazon doesn't carry it and you'll have to enter the details by hand anyways, but that's still fairly easy.
I do not label the books with stickers, RFID or bar codes of any kind. I simply rely on the book name for reference, and since I have very few duplicate books, this usually works. Duplicates can usually be told apart by printing dates or something similar. The library itself is physically arranged by loosely defined categories - I did *not* bother with Dewey.
I have written a complete article about this that may be useful to you. You may also want to contribute to that wiki page which compares different software offering.
Semantics is the gravity of abstraction
I use the Dewey Decimal System for my non-fiction books and alpha-by-author's last name (with chronological for series) for fiction. A simple spreadsheet with DDS#, Title, Author, Shelf/Room, Loaned To, and Loaned On does the organization for me. I could print out barcodes and get a scanner if I wanted to get fancy. For my ebooks, I back them up into Non-Fiction or Fiction folders with the non-fiction subfolders being subject (science, history, etc) and the subfolders for fiction being author's name.
we were still using cue cats!
The Kruger Dunning explains most post on
Says the poor whiny baby. GO back to your protesting 99%er
LOL
Score: 5 Hilarious
Then you have bad luck. The bar code reader I use read every barcode nearly instantaneously.
And I use mine many times a week.
I used mine to demo an inventory system back end becasue the actual barcode reader was broken. It was a second to read a 2 d barcode. It does all the adjusting.
And I don't know what's up with your library, but we can do the barcode checkout in seconds.
hmm
No phone you use works right.
The library system doesn't work right when you use is.
odd.
On a completely unrelated note, when everyone around you is always crazy, you are probably the crazy one. I'[m not sure why the popped into my head.
The Kruger Dunning explains most post on
A tested technology.
Sounds like you are working for your books.... Simplify man.
So we have a geek that doesn't "get" eBooks and eReaders, won't replace most of his shit with digital versions (come on dude, I don't actually believe you have more than one book shelf full of rare copies, the rest are replaceable crap), but then wants a high tech solution to tracking said low tech books, that he rarely lends out by his own admission, instead of using a freaking physical, old school notepad?
Am I the only one thinking "wtf"?
Also, I have to agree with another poster, DeptofDepartments clearly owns too much stuff, as by now it seems that the stuff owns him.
Here's a solution: get rid of most of that shit, keep the few that are really important to you, have a hand built book case (make it out of nice materials, fund it with the sale of shit you aren't keeping), anything you can fit on it and still see the spine you get to keep. Buy a Kindle (or whatever you prefer), load it with 10,000 books that don't matter/are easily replaceable. Use a notepad and pencil that you keep on the shelf with the books to record people who borrow the books, book name, borrower, and date.
You're done and you're welcome.
Seems to me that QR codes would be a good way to track your books. Cheap to print, easy to scan.
Got an iPhone? There's a personal inventory app called MyStuff2 ($5.00) that I use for a whole lot of things, and it already comes with "Books" as a category. When you're adding items, it can use the camera for a barcode scanner and look up your titles on Amazon; it then automatically populates fields like title, author, publisher, genre, page count, edition, ISBN, publication date, and cover photo. For books that don't have a barcode, you can manually type the ISBN. Or you can enter all the data manually.
Once an item is in the database, there are action codes you can select. Item Lent is built in by default, and records the current date. It's up to you to type in the name and info of the borrower. When you view a loaned item, there's a convenient "return item" button to tap.
You can browse the list of all items in an action state, such as "lent" or "returned".
The program is very flexible. You can modify the database schema, adding other data you might find useful, like price, vendor, condition, notes, or what have you. You can modify the actions as well. For example, I modified the "lent to" field of the Loan Item activity to be an address book contact field instead of a typed name. So when I look at the loaned item list, I can tap on an item, tap on the contact, then tap dial to call them.
The app supports importing and exporting data a few different ways (CSV, Excel, PDF, HTML) so you can work with it on a separate machine. It can use all kinds of tools to back up the databases, including Box, Dropbox, iCloud, or you can FTP it to your own systems. And it's always with you, which is great if you're just out and about and happen into a book store.
I also have other categories of stuff in the database. I keep data about all of our home appliances and electronics in there, with information about warranties, repair history, replacement parts, and maintenance schedules.
I originally bought it to keep track of our orchid collection, but it's proven very useful for all kinds of home inventory needs. Best $5.00 app I ever bought.
http://www.maddysoft.com/iphone/mystuff/
John
Passive RFID tags can have a lifespan of 20+ years. Source: http://www.technovelgy.com/ct/technology-article.asp?artnum=47
They're also dirt cheap.
How do public libraries work?
I use Book Catalogue,
https://play.google.com/store/apps/details?id=com.eleybourn.bookcatalogue&hl=en
It's open source, can scan ISBN and pull data from Amazon, free, and can sync w/ good reads.
Best app I've found for that.
http://www.collectorz.com/book/
I've used both their Book and Movie apps for several years.
For the book collection (with just under 8000 in four sections: technical/non-fiction/fiction/collectable) I have a relatively cheap (i.e. $120) cordless bar code scanner.
I've just moved my Video collection (around 700 dvd's) from their PC Application to their Cloud app (which I have mixed feelings about. Nice to have it on the cloud and shareable, don't have to worry about updates or backing up, but lose a handful of useful features - like loaning and list printing).
I'm surprised no one mentioned Alexandria yet: http://alexandria.rubyforge.org/
Some 20 years ago I married an Interior Designer. One day I came home from work and she was excited "come look at what I did!". Head into the office and my 2 large bookcases had been reorganized by book size and color :(
Took me about 3 months to get them back in their proper order, and she never understood why I didn't like her method.
This requirement makes things more difficult for you:
Finally, as many of the books are old folios or fairly precious first editions, everything must be non-destructive and should be removable without damage to the books if need be.
RFID tags, barcodes, and stickers are nifty and serve useful purposes, but they usually cannot be removed from a surface without causing damage, particularly after the adhesive has cured. So you're talking custom book jackets for every book. Given your reluctance to go with RFID, think optical, such as UPC codes or QR codes... but carefully consider their purpose. It sounds like you basically just want to keep track of lending books out. It doesn't sound like you need subject searching capabilities for your collection, and it doesn't sound like you'll be circulating thousands of titles per year. So what would take less time over the remainder of your life span: manually entering a title and the borrower's name into a calendar (w/ a reminder set to go off after a ~4 weeks) a few times a year, or creating thousands of book jackets, cataloging the data, and syncing it with QR codes... then manually entering the name of the borrower? Or will you create a circulation account, and give your friends cards, as well? (You'll still need to enter their personal info once, anyway.)
So keep track of the physical collection this way: face your books. This means align them so that the spines rest at the edge of the shelf (rather than pushing them as far back as they can go.) While it won't fool a careful book thief, most people don't even notice when a shelf is faced. When shelved this way, it's easy to see what books have been dislodged. Keep track of your circulation by just entering borrower name/title into a google calendar as a future appointment, and have it set to email/text you a reminder to get it back.
Even if you donate to the library, they are not obligated to add them to the collection. If a number of your books are pre-ISBN that pretty well guarantees they will not. They need contemporary books people want to read. Unless they are a university or archival library, they are not interested in keeping old stuff. They'll just booksale the stuff they don't want.
librarything.com is a pretty easy way to get your books cataloged. I use it for my collection of over 2,000 books. Calaloging is not just a matter of finding a Dewy number and sticking it on there. MARC (Machine Readable Catalog) is a very intensive and complex method of tagging everything from size to subjects. The neat thing about librarything is that once you get your books in there, with as minimal effort as possible, you can downlad a comma delimited file of the full record to import into any system you want. Cataloging is intensive and time consuming so you want someone else to do the bulk of the work. Don't underestimate the amount of work involved here.
If you REALLY want a serious library automation system there are a couple of open source systems out there: Koha.org is one and Evergreen (open-ils.org) is another. These are real and complex systems with OPAC (Online Public Access Catalog), check-in/out, etc. I wouldn't do this unless you were really hard core.
Google home library software and you will find a ton of stuff.
P.S. I worked in the library automation field for about 30 years as one of the first "systems librarians."
How about a moderation of -1 pedantic.
Marry a librarian, and just leave your books around. A system will develop.
The Kruger Dunning explains most post on
A pad and pencil When you lend it out, right it down with the name and date.
My guess is you will only need a single 3x5 piece of paper to write down every book you lend out in a year. If you need more, turn the page on the pad or step up to 8.5x11 paper. Set the pad on one of your bookshelves so you know where it is at.
I can search my books. It can be as interesting as searching for a literally passage or scientific fact, or as banal as searching for the rude bits in a novel without reading the whole book.
I can store literally MILLIONS of E-books on a modern portable hard drive if I wish. My own collection is probably closer to 50,000 and consists of free E-books, but I can pull them out of my pocket and read them on a laptop on the train. I can search my entire collection for a book or a passage. If I don't buy books with DRM I'll never lose a book.
The current dedicated readers are total junk. I prefer a proper laptop with a proper keyboard. Unfortunately any book with diagrams may also have those diagrams at too low a res so you have to be picky about what you download.
And no you can't toss them around, get them wet, dirty or sandy, or let them run out of charge if you want the system to be usable.
But search and storage are not small things.
http://tellico-project.org/
I own around 3000 books and have used it for several years. It may not do everything you want, but it is probably close.
Proper indexing (0-9, A-Z, by genre) and Libreoffice Calc/Excel will go a long way! At least if you need to import your data into SQL or something, you can easily do it from an spreadsheet.
Also some proper shelving that isn't too deep will go a long way to ensure all the spines are visible. If this sounds too low tech for you, then go ahead and print out your QR or Barcodes.
add additional rooms for each category of book. build an especially large room for 'Potty Trained at Gunpoint' and other anal retentive titles
I have the same problem. I went and bought a software program that allows me to use my cellphone as a bar-code scanner and it puts the data right into the software program on my desktop and the program also syncs with the cloud.
There are different options out there, the one I used is from Collectorz.com. As for finding and checking them out, either come up with a system that works with your likes/dislikes or go alphabetical by author last name (like all book stores do) or some other way to simply sort through them all.
I have a lot of books too. I organize them by topic. But often a book fits into many topics. In that case, it's a personal significance kind of thing. In the end, organizing books is like organizing knowledge. I mean, it IS organizing knowledge. I would look existing library systems, as some have pointed out, or I would reflect pensively on the structure of knowledge itself. You probably need a big machine that stores the books in a complex, dynamic 4 dimensional arrangement (read 3d structure with patterned shifts in time). I would build a mechanical brain. You could read through Neal Stephenson's The Baroque Cycle for Leibniz's ideas on a mechanical library brain.
But actually, I've ended up being facetious too. In reality, my input comes down to: do you value the knowledge or the monetary value of your books? I have books for a couple reasons. I don't trust the long term storage of digital information in our short-sighted society (and I'm investing in knowledge, not first editions). You seem to be more all about the monetary aspects of your books. In that case, it seems like you should probably organize them accordingly. Get an expensive shelf with climate controls for your most valuable books, and do some sort of topical arrangement thereafter.
Make yourself a basic SQLite database, maybe hosted on a PHP server or whatever you dig. I like Sinatra. After that, the interface is just a matter of how much pizzazz you want to add, and if you want it to be public.
Once you have items tagged with an ID number, saved in your trusty database, you can play with metadata. For something simple, try Dublin Core. If you want to show your collection to the world, try Omeka.
After that, you're going to need a script with reminders for people that inevitably will want to read your book. Every time a person borrows a book, make the script use cron to email them every week, to remind you to give it back.
http://www.collectorz.com I have a few collections never tried it with books though i do use there movies music and video games collectors software the good part about this is there is a lending feature and it also compiles the "cost" of the collection for insurance purposes. it aint free but work every cent
Using scanners, RFID and the like is already "industrial" - i.e. professional library - level. Scanning the ISBN is not really faster than typing it into a search bar.
If you are a collector, than managing your collection is part of the fun. It shouldn't become a chore. I use tellico to manage my small (1000+) collection. It's simple to use and easily adjustable to my needs.
Access 97 comes with a free example template for managing a library. I've used it for years.
As a librarian I would suggest the following open source solutions. For cataloging you can use Easy MARC (Machine Readable Cataloging). You can download MARC records for free from LC (Library of Congress) or most public libraries using the Z39.50 Protocol. You can use the following ways to look up MARC ranked by preferred methodology: ISBN, LCCN (Library of Congress Cataloging Number, printed in most books from the 1940's on), author and title. If there are more than three authors or if the book has just an editor than the main entry will be the title only. You can classify items using Dewey, LC, or any other methodology. Jefferson cataloged his books by size, smaller books on top larger on bottom. This can be the most efficient way for maximum space utilization. As for looking up and managing the collection you can use an open source ILS (Integrated Library System) such as Koha, or a number of free web sites. Barcodes and classification numbers can be put on slips of paper or card stock that are no acidic. RFID is not necessary, location of an item can be recorded in the MARC record or as comment in the ILS.
Booxster for Mac and ios
I have been using BookCAT by FMProgramvare for years. Supports loan information and checkin/checkout.
http://www.fnprg.com/bookcat/
Even a cool add-on called CatWEB to put your collection online:
http://www.lotsocds.com/
Just remember - if the world didn't suck, we would all fall off.
You can find the Dewey Decimal (DDC) and Library of Congress (LOC) call numbers on the verso of the title page in most of your books (usually towards the bottom). Stick with one system or the other. If the call numbers aren't there, you can find accurate LOC call numbers already created for your books via the Library of Congress catalog search: http://catalog.loc.gov/webvoy.htm
Just type in the ISBN or title to find the book and then once you find it the record should include the call number. Here's the LOC classification guide: http://www.loc.gov/catdir/cpso/lcco/
If you go with the DDC you can even use it catalog all other worldly possessions including pets and loved ones.
You can probably guess what my occupation is by now...
I organize mine much like a bookstore:
Fiction goes alphabetical by author. Within a particular author, arranged by title or series and number in series. Anthologies by name of editor; multi-author series are a separate section, arranged by series title and number in series. Fiction all together is about two bookcases, thanks to a large culling that happened when I had to move after a divorce, so I don't feel a need to separate by genre.
Non-fiction is organized more loosely, but books on the same subject are together. If a single subject starts to occupy more than one shelf, then it's generally time to start subdividing it more finely (e.g., my dozen-odd dinosaur books are a category, but my computer books are divided into programming, security, operating systems, and other finer divisions, since I have about three shelves of a bookcase of "computer books").
My RPGs are arranged by title and edition, except for xD&D, which gets its own section arranged by edition and core/non-core/3rd-party supplement status.
Learn the Dewey Decimal System. The only downtime you'll have is when you sharpen the pencil.
http://www.collectorz.com/book/
Use ISBN, Scanner, Cloud Database, iOS app, Lend, Scan covers.... more!
-Eric
I like readerware which also has programs to handle cd's and dvd's ad if you ave the isbn to download most of the information from te net.
http://www.readerware.com/ witch is Available for Windows, Linux, Mac OS X and Android. Not free, but I like it.
I have an older version that allows me to export to a old palm so I can take a copy with me when I go book shopping.