225 Books: 03/14/07
After work Ian and I wild released another seven books. On our way to Starbucks to make the release, Ian asked me how many books we have managed to clear from our collection since January. He wanted to know how well we were doing on controlling the inflow of books to our collection. I gave him a rough estimate of 230 but I didn't know for sure.
Tonight I took about ten minutes to figure out how to get answer out of my BTC database. I knew it would involve a query across two tables and some Boolean logic to separate the ones that have an entry in both tables from the ones that are only in the "books in" table. Ten minutes of fiddling around and I had my answer and for kicks, exported it to Excel. The answer is 225 as of today.
In real word terms, 225 fewer books means one less bookshelf. We used to have a bookshelf by our front door. I've hated it for the two years it's been there. It made our entry landing look so small and cluttered. Now the books are off of it and the shelf has been put to better use in the upstairs closet. In its place we plan to put a potted tree (maybe a yucca of some sort).
bookcrossing | clutter | database
