Difference between revisions of "User talk:Aperfectring/Random image page"
imported>Phyzome (#geohashing I posted a schema suggestion.) |
imported>Aperfectring (→Schema suggestion: And some comments.) |
||
| Line 53: | Line 53: | ||
INSERT values into the `category` table ("GPS", "XKCD Marker", "Wildlife") and link them to images using the `wikiCatted` table. | INSERT values into the `category` table ("GPS", "XKCD Marker", "Wildlife") and link them to images using the `wikiCatted` table. | ||
| + | |||
| + | ===Comments=== | ||
| + | I do like this better than my idea. However, the wiki likely not swept on a regular basis, as gathering the categories of each of the images would probably be fairly wiki-intensive and time consuming. I will look into that, but the more likely it will be updated once, and randomly refreshed. --[[User:Aperfectring|aperfectring]] 21:37, 17 February 2010 (UTC) | ||
Revision as of 21:37, 17 February 2010
I like the idea! But when I think about some of the images, there are cases where voting is just tiresome:
- Some of the pictures I have taken (and one of the two pictures I saw at my first try of your page) are blurry...
- ... or they are really really boring like this one ...
- ... also there is
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)
- 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!
- Same as point #1
- 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)
Contents
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.
Comments
I do like this better than my idea. However, the wiki likely not swept on a regular basis, as gathering the categories of each of the images would probably be fairly wiki-intensive and time consuming. I will look into that, but the more likely it will be updated once, and randomly refreshed. --aperfectring 21:37, 17 February 2010 (UTC)
