Vent of Hearing

A Library Application

Last night, I finished another book (I finished two in a weekend) and thought what I would put in a review of the book. Then I thought of a really neat application that would control the book review process and much more. It would, of course, be written using the xPlod database, and handle the output to this webpage and updating my .sig to reflect what I was currently reading.

It would maintain output on what I was reading, what I'd like to read, what I've read but haven't reviewed, what I've reviewed, and what I want to do with the book after reviewing. By that I mean what, physically, I'd do with the book. Space is valuable. I couldn't possibly keep all the books I own or will own on a bookshelf. There just isn't enough wallspace. In one respect what I do with the book is better than a 1-5 rating.

***** Gets a place on the bookshelf. (wow, impressive)
**** Into the loft. (Worthy of a reread)
*** Give to friend/relative (Not a bad book, but not worth keeping)
** Give to charity (Not a good book, give away)
* Burnt (A bad book; A Charity Shop wouldn't be able to get rid of it)

Anyway, I spent sometime speccing out the database design, wondering if I needed to map the changes Aquarius made to the insert statement to the rest of the commands, making a note to work out how to update it via email before realising I could have spent the time better by just reviewing the books.

Also, visit What Do I Know - Library to see someone who has used MovableType to manage his library.