Managing My Book Collection
By Daniel Miessler on October 25th, 2005: Tagged as Books | Database | General | Musings
I’m horny for books. I read them, I collect them, I admire them — especially those that are information security related.
Recently I’ve been running into a problem in the bookstore while browsing. I come across a title that looks intruiging and then realize that I’m not sure whether or not I already own it. It’s a horrible feeling, really. The old me says buy it anyway and give it away if it’s a duplicate, but the new me demands that I check first to see if I own it.
The obvious solution is to be able to check, from the bookstore, whether or not I actually already have a given book. So I made a list of my books in vi, sorted it for easy searching, and put it on the site.
Now, whenever I’m in doubt, I can conjure the page over my Blackberry and check to see if I have the damn thing before I buy it. :) W00t.
Next I’ll complete my previous project of manually building a database to do this using LAMP. I did it already, but my table structure was primitive and the only functions I had were viewing all books and adding new books. What I’d ultimately like to be able to do is search by any field, e.g. author, edition, subject, etc.
Another thought I’ve been throwing around is the concept of tagging along the lines of Delicious. In other words, take each book and give it a series of tags. Then, just as with Delicious and Flikr, I could search for all books with a given tag (or even multiple tags). As an example, it’d be cool to call up all books of mine that have to do with database, or all my Python books, etc. Anyway, this’ll work for now.
--

If you hadn’t sworn off Windows, I’d say you could easily create a web form to do a book search, add books, etc. in your database using Visual Studio.NET
But I’m sure it’s not too hard to make something like that using php and mysql (or the database of your choice).
Comment by Tim — 10/26/2005 @ 8:53 am
OK, I’ve got a not-connected-to-the-world-except-when-synching Palm OS device rather than a Blackberry, but I’d assume that there is software for the Blackberry that lets it view spreadsheets. Why not just create a spreadsheet and put it in your Blackberry? It wouldn’t take much space (not including the spreadsheet viewing software). AND, you’d be able to search, sort by title, sort by author, sort by subject, etc.
I know … it’s cooler to connect wirelessly to your home computer, but …
Comment by Carl M — 10/26/2005 @ 1:21 pm
This looks like a job for Google Base!
Comment by Jason — 10/27/2005 @ 6:06 am
What about http://www.librarything.com/
Comment by Dave — 12/3/2005 @ 4:43 am
nashville hotels…
wisps.authorization bilingual,substations updates continental clear hotels http://www.popular-hotels.com/ …
Trackback by nashville hotels — 5/21/2006 @ 6:42 pm