Monday, February 21, 2005

Online database, part 2

misterjoel's post of corrections has reminded me that I haven't done much yet on my previously-proposed online database. I have a bunch of ideas for this, but it occurs to me that there are several ways to design this, and that the members of this forum will undoubtedly be able to help me decide which is the best way to proceed, by giving me conflicting and contradictory input :-)

So with that in mind, here are a few of my ideas for the underlying content of the database. Please feel free to comment if you think any of these are good or bad ideas.
  1. The database will be able to contain multiple entries for a comic, if it has been scanned more than once. This will allow for situations such as a cover-to-cover scan that is lower resolution, versus a more detailed scan that doesn't have ads, or is missing pages.
  2. Each comic entry will be able to be flagged for the following conditions: Missing pages, Missing cover, Scanned complete (a.k.a. cover to cover, with ads), Reprint, Remix (reconstruction), etc. I am also considering some sort of "resolution" flag, to indicate the approximate scan resolution of the comic; maybe something like "Under 800, 800-1200, 1200-1600, Over 1600".
  3. I've thought it would be nice to include who scanned a particular issue. BD's database does have some information pertaining to this, and I'm sure others are keeping track of this as well. Do you think this would be useful or desirable?
  4. To try to eliminate the frequent problem of mis-sorting due to variations in spelling of the book title, the database will have a separate table with the standard names of each book. This table will include the "canonical" title for each book series, along with name changes that the book went through. The exact naming conventions to be used are open for discussion.
  5. Each canonical title above will have one or more "genre" flags associated with it. I say "one or more" because some books fall into more than one genre (i.e. war romance, funny animal superhero, etc.) A question would be, are there any books that fall into more than two genres?

Please note that the above ideas all have to do with the data contained in the database, and not how it will be viewed or queried. Also, it will be possible to view lists of books without having to see all of the above information, but it will also be possible to filter the information according to a user's preferences (i.e. only show me DC superhero, mystery and sci-fi books).

Comments, please?

Sunday, February 20, 2005

Corrections

A few corrections for BD's list:

Missing from the list, but posted last June
Four Color 689
Lone Ranger 48

Let me know if anyone needs reposts.

A few listing name changes so that they sort better:
Roy Rogers 50, 63, 84-85, 97, 106
Roy Rogers & Trigger 135
Roy Rogers Comics 82, 89
Roy Rogers & Trigger is correct, though that should include 92-131. I think all under "Roy Rogers" would be least confusing.

Ripley's Believe it or Not 1, 24, 35, 43, 47, 49, 56, 75, 84-85
Ripley's Believe it or Not True Ghost Stories 59

Rin Tin Tin 7-8, 10-11, 14-18, 20-24, 27, 30-31, 35
Rin Tin Tin & Rusty 20, 22

Rima 6-7
Rima the Jungle Girl 1-7

Richard Dragon Kung Fu Fighter 6
"Richard Dragon, Kung-Fu Fighter" 9

Return of Tarzan (Dark Horse) 1
Return of Tarzan (DH) 2-3

Redmask of the Rio Grande 1
Redmask on the Rio Grande 2-3
Of the Rio Grande is correct

Question 1
"Question, The" 2-36

Popular 137
Popular Comics 19, 27

Pogo Possum 3
Pogo Possum 5
An extra space in the first listing throws off the sort.

Picture Stories from the Bible New Testament 1
Picture Stories from the Bible NT 2
Picture Stories from the Bible Old Testament 2
Picture Stories from the Bible OT 1

Phantom (King) 25
Phantom King 20, 22

Patsy & Hedy 96, 105
Patsy & Hedy Career Girls 106-108
Patsy and Hedy 78

Pals N Gals Double Digest 73-75
Pals 'N' Gals Double Digest 81

Oz-Wonderland War 1-3
Oz-Wonderland Wars 1

Nevermen Streets of Blod 1
Nevermen Streets of Blood 2-3

Masters of the Universe 3-4
Masters of the Universe LS 2
Masters of the Universe MS 1

Lone Ranger's Famous Horse Silver 11
Lone Ranger's Horse Silver 3
The full name appears to have been The Lone Ranger's Famous Horse Hi-Yo Silver.

Lone Wolf 11, 13
Lone Wolf & Cub 10, 12

Kitty Pryde & Wolverine 5-6
Kitty Pryde and Wolverine 1-4

Huey Dewey & Louie (Junior Woodchucks) 2-3, 10, 26
Huey Dewey & Louie Junior Woodchucks 3"
Hughie, Dewey & Louie Junior Woodchucks" 2
Junior Woodchucks 2, 10, 12, 26
Overstreet lists it as Huey, Dewey Louie Junior Woodchucks.

Thanks for keeping the list, BD. Sorry to be such a pain.

Saturday, February 19, 2005

My Most-Wanted List

I am in search of the following books. I will pay 100% guide for low grade copies of the following:

World's Finest 8, 9, 28
Looney Tunes 52, 82-85, 88,96
Smash Comics 32,37,38,39,47,48,52,55,59,60,62,64,78,79,80,81,82,83,84
Candy 8,9,11,14,15,16
Jamboree 2,3
Nutty Comics 5
Zoo Funnies (Vol 1) 6,8,9,10

Thursday, February 17, 2005

Here's a Cool New Meme

The 100 Things I Like Best About Comics. Michele Catalano's effort is here. Johnny Bacardi kicked it off here.

Update: Johnny Bacardi graciously acknowledges his getting the idea from here, who got it from here.

Wednesday, February 16, 2005

Happy 66th Birthday, William Van Horn!



An article about the man who drew over 800 pages of duck comics.

Sunday, February 13, 2005

New and Improved Marvel Masterworks

Check out the scans!

These ones will include the back up stories!

Thursday, February 10, 2005

Superhero Superbowl Ad

For those that didn't see the Superhero Superbowl ad it's online
here.

It's a bit hokey.

The rest of the superbowl ads are there too, including a few that was supposed to air, but the networks said No to.

Friday, February 04, 2005

All I Want for My Birthday

Classic ebay auction.

Thursday, February 03, 2005

IRC Server Problems?

A lot of us have had trouble getting into the chatroom the last couple days; looks like UnitedUsers is down. Try this one:

united.ludd.ltu.se

Wednesday, February 02, 2005

Happy 93rd Birthday, Creig Flessel!



Interview with Creig Flessel.