User talk:Aperfectring/Random image page

From Geohashing
< User talk:Aperfectring
Revision as of 21:31, 17 February 2010 by imported>Phyzome (#geohashing I posted a schema suggestion.)

I like the idea! But when I think about some of the images, there are cases where voting is just tiresome:

  1. Some of the pictures I have taken (and one of the two pictures I saw at my first try of your page) are blurry...
  2. ... or they are really really boring like this one ...
  3. ... also there is Minesweeper geohash flag.jpg and similar pictures.

While it is possible (and probable) that they will be voted down each time they show up, it will take very long for them to end up at the lower end of the list. It would speed things up if there was a "This picture really sucks, I want to give it -10 points" button. That's just my 2 cents because I'm lazy and I don't want to see the boring pictures often, I won't mind if you ignore this proposal. Yeah, ignoring is probably best. Why am I still typing? Ah, deleting this post is too much effort. I think I'll find something to occupy myself now. Bye. - Danatar 17:41, 17 February 2010 (UTC)

  1. Yeah, that will happen, but there are also a lot of hidden gems that people wouldn't see otherwise, my tendency is to err on the side of caution, so that we can see all the images!
  2. Same as point #1
  3. That file will be filtered out, because it is not in [[Category:Meetup in LAT LON]].
There has been talk of adding a blacklist, but I think the best way is to just have the probability weight the choice of images based on their current rating. Unfortunately that means there will be some boring images you have to slog through, but as time goes on, it should get better and better. --aperfectring 17:51, 17 February 2010 (UTC)

Schema suggestion

`image` table

Column name Type
imageID CHAR(64)
imageName VARCHAR(65535)
votesUp INT() UNSIGNED
votesDown INT() UNSIGNED
isCached BOOL

`category` table

Column name Type
catID INT() UNSIGNED
catName CHAR(64)

`wikiCatted` and `reportCatted` tables

Column name Type
catID INT() UNSIGNED
imageID CHAR(64)

`wikiCatted` is emptied and repopulated on each sweep of the wiki. `reportCatted` is added to when people use the app. (Perhaps that table should have IP address and timestamp as well?)

Usage

INSERT values into the `category` table ("GPS", "XKCD Marker", "Wildlife") and link them to images using the `wikiCatted` table.