After recently moving down to Virginia and getting confirmation this afternoon that the majority of my books (the ones I didn't take with me) are being shipped down this week; coupled with the completion of my first home-built bookshelf on Friday, it got me thinking about a topic that crops up here every once in a while: how does everyone shelve and catalog their books? I went looking for the previous discussions but was unable to find them 
Shelving
I shelve my books in a very specific order: Enterprise, TOS, TNG, DS9, VOY, NF, the other novel-only series; other SF series, fantasy series, modern series (i.e. Tom Clancy); then the rest are alphabetical by Author, then (in the past) title (but I'm thinking about changing that to publication date). I've created a very detailed shelving-number scheme. Actually, within each Trek series, ot generally goes numbered, novelizaitons, unnumbered, relaunch. This ordering plays into my...
Cataloging
I design web sites and database-based systems as a hobby and have been using a web-based database of my own design for several years now. Whenever I get a new book, I add it to the database and place it in its proper shelf order. I also keep track of the purchase date, price, etc. as well as whether i've read the book and if I feel inclined to write a review.
I'm curious what everyone else uses both as shelving schemes and as ways of keeping track of what books you have; and what books you want/need to complete your collections.

Shelving
I shelve my books in a very specific order: Enterprise, TOS, TNG, DS9, VOY, NF, the other novel-only series; other SF series, fantasy series, modern series (i.e. Tom Clancy); then the rest are alphabetical by Author, then (in the past) title (but I'm thinking about changing that to publication date). I've created a very detailed shelving-number scheme. Actually, within each Trek series, ot generally goes numbered, novelizaitons, unnumbered, relaunch. This ordering plays into my...
Cataloging
I design web sites and database-based systems as a hobby and have been using a web-based database of my own design for several years now. Whenever I get a new book, I add it to the database and place it in its proper shelf order. I also keep track of the purchase date, price, etc. as well as whether i've read the book and if I feel inclined to write a review.
I'm curious what everyone else uses both as shelving schemes and as ways of keeping track of what books you have; and what books you want/need to complete your collections.