Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Hacker News historic upvote and score data

hn.dunkirk.sh

Post reply on HN
Print view View original

21–30 of 50 posts

Re: Show HN: Hacker News historic upvote and score data

#21

Post by zX41ZdbW »

I'm also collecting this data, and it allows rendering beautiful heatmaps like here: https://github.com/ClickHouse/ClickHouse/issues/59020

Try: ssh play@play.clickhouse.com

    SELECT id, max(score) AS s, max(descendants), argMax(title, update_time), arrayStringConcat(arrayMap(x -> format('\x1b[38;2;{0};{1};{2}m\xE2\x96\x88\x1b[0m', least(greatest(sqrt(x / 10) * 255, 0), 255)::UInt8::String, least(greatest(sqrt((x - 10) / 50) * 255, 0), 255)::UInt8::String, least(greatest(sqrt((x - 50) / 250) * 255, 0), 255)::UInt8::String), arrayDifference(arrayFill(x -> x != 0, maxResample(now() - INTERVAL 2 DAY, now(), 3600)(score, update_time))))) AS bar FROM hackernews_changes_items WHERE id IN (SELECT arrayJoin(ids) FROM (SELECT ids FROM hackernews_top WHERE type = 'top' ORDER BY update_time DESC LIMIT 1)) GROUP BY id ORDER BY s DESC LIMIT 10

Re: Show HN: Hacker News historic upvote and score data

#22

Post by clacker-o-matic »

zX41ZdbW wrote: post #21

I'm also collecting this data, and it allows rendering beautiful heatmaps like here: https://github.com/ClickHouse/ClickHouse/issues/59020 Try: ssh play@play.clickhouse.com SELECT id, max(score) AS s, max(descendants), argMax(title, update_time), arrayStringConcat(arrayMap(x -> format('\x1b[38;2;{0};{1};{2}m\xE2\x96\x88\x1b[0m', least(greatest(sqrt(x / 10) * 255, 0), 255)::UInt8::String, least(greatest(sqrt((x - 10)…

Oooh thats awesome

Re: Show HN: Hacker News historic upvote and score data

#23

Post by clacker-o-matic »

namiwang wrote: post #18

nice job! I once created [Track HN]( https://track-hacker-news.com ) which does similar things! I've already archived historical data of scores/comments/ranks. It seems our projects overlap - maybe we can combine our efforts to hack something even cooler :).

Ooh! Id love to talk!

Re: Show HN: Hacker News historic upvote and score data

#24

Post by clacker-o-matic »

das_keyboard wrote: post #17
bilekas wrote: post #9

Are you sure this data is correct ? There is a listing of the "Most Upvoted Story" at 390, but I feel like I have seen regularly items higher than that. One example I see today is : https://news.ycombinator.com/item?id=44174965 with 393.

If I understand correctly it does only show stats for the current frontpage (aka top 30). So it's the "Most Upvoted Story (on the frontpage right now)".

Yeah it would probably be better to phrase it that way

Re: Show HN: Hacker News historic upvote and score data

#25

Post by clacker-o-matic »

Zobat wrote: post #16
TheEdonian wrote: post #10

Looking at the charts they all seem to take off. To me that begs the question, do they take off because they hit the front-page and get all the attention, or are some of them bought upvotes like on Reddit?

Isn't this because upvotes "early" are worth more than upvotes later?

Thats my guess; also survivorship bias. Those that make it have to show quick promise early on in order to hit the front page

Re: Show HN: Hacker News historic upvote and score data

#28

Post by clacker-o-matic »

mocmoc wrote: post #11

This is done with claude . You know why I know. looks awesome.

Lol fair; i used this project as a bit of a playground for zed agent mode. My conclusion is that its okayish for ui but generally terrible at responsive design and really bad at db queries. I had to fix most of the ui since it would just flat out not work on mobile

Re: Show HN: Hacker News historic upvote and score data

#30

Post by clacker-o-matic »

leoff wrote: post #14
clacker-o-matic wrote: post #3

Earlier quoted context omitted.

That’s a good idea; shouldn’t be terribly hard to implement

it's easy: 1. add `position: relative;` to `main-container` 2. add `position: sticky; top: 0;` to `graph-container` you need to figure out what to do in the mobile display though

Thanks!!! My sleep addled brain couldn’t quite figure it out last night
Post reply on HN