News for hackers. Stuff that matters.
Re:I Want to Fix Goodreads by xuhu on Saturday September 12, 2020 @04:11PM (#24455211)
How did you define the actual "best books" ? I usually pick a group (Goodreads users in country x), scrape the books of all its users, and sort them by frequency: https://github.com/harjoc/goodreads-group-books
Re:I Want to Fix Goodreads by bbarnett on Sunday September 13, 2020 @04:30AM (#24459362)
Thinking on johnfn's response, and yours, these are all simple SQL queries. You could easily delineate to others what each query does, and let people choose from a list.

EG "best average" "most reviewed" "users in country + frequency" and such.

This doesn't even need to hit performance, as these queries could all run on a secondary SQL server, be cached in redis/whatever once an hour, or even day.

After all, this sort of list output doesn't need to be second by second changing.

So simple to implement, non-performance impacting, which makes it even more curious as to 'why not'. Likely, a UI/UX person thinks it will 'confuse' people.

(I know that may not be the case, but it seems to kill more sites, and more flexible functionality, than anything...)