Cooper: Diane, last night I dreamed I was eating a large, tasteless gumdrop, and awoke to discover I was chewing on one of my foam disposable earplugs. Perhaps I should consider moderating my nighttime coffee consumption.
-- "Twin Peaks"

Search This Blog

Sunday, January 2, 2011

Reading in the 21st Century

I finally have my "books read" list into a mysql database. I haven't come up with any good report output, but I'm imagining I'll have to write some kind of program to generate it; something automated and better than the old manually created lists I used to make. Obviously, I'm not setting the bar very high, I know.

Given that, here's a simple list of the books I've read in the last decade.  Frankly, I'm surprised I was able to do this without relying on stored procedures or what not.

I realize this looks sloppy in Internet Explorer. But it looks just as intended in Firefox!  The perfectionist in me wants to waste the rest of the night trying to get it to look good in "all" browsers -- but the realist in me says, meh.
mysql> SELECT distinct b.title,
    -> (select group_concat(aa.firstname,' ',if(aa.midname is null,'',concat(aa.midname,' ')),aa.lastname)
    ->    from authors aa,books_has_authors bb where bb.authors=aa.oid and bb.books=b.oid ) "Authors",
    -> concat(b.monthread,'/',b.yearread) "Finished"
    -> FROM books b
    -> WHERE b.yearread>=2001 order by b.yearread,b.monthread;
+--------------------------------------------------------------+---------------------------------------+----------+
| title                                                        | Authors                               | Finished |
+--------------------------------------------------------------+---------------------------------------+----------+
| Ways That Are Dark: The Truth About China                    | Ralph Townsend                        | 7/2001   |
| Check Your Local TV Listings                                 | Omar Williams                         | 9/2001   |
| Lord Of The Rings, The: The Fellowship Of The Ring           | J.R.R. Tolkien                        | 12/2001  |
| Lord Of The Rings, The: The Two Towers                       | J.R.R. Tolkien                        | 5/2002   |
| Death Of The West, The                                       | Patrick J. Buchanan                   | 7/2002   |
| Final Judgment                                               | Michael Collins Piper                 | 1/2003   |
| Jennifer Government                                          | Max Barry                             | 1/2003   |
| Planet Of The Apes Revisited                                 | Joe Russo,Larry Landsman,Edward Gross | 8/2003   |
| Franchising For Dummies                                      | Dave Thomas,Michael Seide             | 10/2003  |
| Lord Of The Rings, The: The Return Of The King               | J.R.R. Tolkien                        | 11/2003  |
| Sellout: The Inside Story Of President Clinton's Impeachment | David P. Schippers,Alan P. Henry      | 1/2004   |
| New Gambler's Bible, The                                     | Arthur S. Reber                       | 3/2004   |
| Basic Blackjack                                              | Stanford Wong                         | 4/2004   |
| Blackjack: The Real Deal                                     | Phillip J. Vogel                      | 4/2004   |
| Snow Crash                                                   | Neal Stephenson                       | 4/2004   |
| Losing Bin Laden                                             | Richard Miniter                       | 6/2004   |
| Madame Hillary: The Dark Road To The White House             | R. Emmett Tyrrell,Mark W. Davis       | 9/2004   |
| Diamond Age, The                                             | Neal Stephenson                       | 10/2004  |
| Cryptonomicon                                                | Neal Stephenson                       | 11/2004  |
| Acting                                                       | Richard Boleslavsky                   | 12/2005  |
| Moslems: Their Beliefs, Practices, And Politics              | Gabriel Oussani,Hilaire Belloc        | 1/2007   |
| Quicksilver                                                  | Neal Stephenson                       | 8/2008   |
| Confusion, The                                               | Neal Stephenson                       | 10/2008  |
| Mystery                                                      | Peter Straub                          | 8/2009   |
| System Of The World, The                                     | Neal Stephenson                       | 10/2010  |
+--------------------------------------------------------------+---------------------------------------+----------+
25 rows in set (0.11 sec)

No comments:

Post a Comment