- Home
- About
- Reviews
Archive by Date Authors: A to Z Titles: A to Z Animal Themed Books Childrens (all ages) Books for Older Children Children's Monster Books Children's Picture Books Children's Books: 12 - 24 months Fiction Graphic Novels and Manga LGBT Mysteries and Thrillers Non-Fiction Science Fiction, Fantasy and Horror Short Stories YA
- Blog
- 2012
- 2011
- 2010
- 2009
- 2008
- 2007
- 2006
- 2005
- 2004
- eBooks
- Wishlist
- Art
- Contact Me
- Subscribe by Email
Comments for Books Received
Books Received: 08/17/07
Earlier this year I decided it was time to figure out just how many books we have. The easiest way to do it was to pull the relevant info off my BookCrossing shelf. I know there is a widget for Firefox that can tell me exactly how many books I have and BookCrossing is beta testing an option on the site to do the same thing. But I wanted more information that either option could provide. I wanted a way to track the flow of books in and out by date. I also wanted to learn SQL and what better way?
With close to 4000 records and no easy way to get the date received for a book (it's not one of the sorting options on BookCrossing), I had to click on each and every book on my shelf. It's taken me a number of months doing it whenever I had the time to spare. At last I'm done with the initial data entry. Now I just have to clean up any duplicates and then start to put in the release dates for books I've released from 2003 through 2006. My data for 2007 is current.
So far I have graph that shows the books received over the last four and half years:
The data for 2004 and 2005 spikes because those were the years when I was actively registering all of my books (including books I have no intention of releasing). I've been thinking of doing a book database for a long time! Years 2003, 2006 and 2007 have some personal collection registrations but are a far better sampling of actual book acquisitions.
Comment #1: Saturday, August, 25, 2007 at 20:10:09
Interestingly, 2005 was my biggest year, too. That's because I won the sweeps at BookRelay.
I'm still not caught up from that!"