How do you have 40mm rows of data on Show HN for only ~126,000 stories?
Track HN: Survival Rate of Show HN Stories
41–50 of 75 posts
Re: Track HN: Survival Rate of Show HN Stories
#42I know you mention there are lots of reasons for false positives and negatives, but does your methodology account for length of time at all? Meaning, if a project was posted to HN in 2009, it could have been successful for 14 years and then closed down, or just changed URLs somewhere along the way, and in that case it would be counted as a failure even though it wasn't. Likewise, if it was posted in May, 2023 and is…
Exactly. Some of these graphs are really flawed. Like the heatmap for the top 1% which pretty much mirrors the submission heatmap. I want to see what portion of submissions for that time slot reached 1%, not of all submissions. There could be time slots that perform exceedingly well outside of popular times.
Re: Track HN: Survival Rate of Show HN Stories
#43> Looking for a Sponsor to Host the Database PubliclyPermalink > In the meantime, it’d be great if anyone can query the database. I tried to host a public database and real-time query interface online, but couldn’t afford the bill for a smooth Postgres instance to hold around 20G (40M rows plus indices) data. While a $20 instance could suffice, it’s pretty slow from usable, comparing to the local one on my M2 MacBook…
Nice, but seems to be last updated 2022-12-12 and funnily the IDs that don't exist have a time of 1970-01-01 00:00:00
Re: Track HN: Survival Rate of Show HN Stories
#44How do you have 40mm rows of data on Show HN for only ~126,000 stories?
Comments and the stories that are not "SHOW HN".
From TFA:
> For this analyze, I considered submissions made before May 31, 2023, 23:59 UTC. The dataset consists of 4,714,023 stories and 30,363,533 comments from 867,097 users.
Re: Track HN: Survival Rate of Show HN Stories
#45What timezone is used for the submission heatmap?
Re: Track HN: Survival Rate of Show HN Stories
#46What is the timezone for the heat maps? I assume UTC but wanted to check.
Re: Track HN: Survival Rate of Show HN Stories
#47I'm happy to say that the reports of my death here are greatly exaggerated :) I'm the owner of both #4 and #140 on the Top-scoring Show HN Stories that Didn’t Survive... but both are very much alive! #4 StackSort was a Github.com page, but on 2021 they made it so only Github.io wroks. If dang sees this, I'd really appreciate if you could change the URL for https://news.ycombinator.com/item?id=5395463 to use github.io…
How on earth did you get readme.com? I'm assuming someone else owned it, whenever I see that and all the "make an offer" links I move on and ignore it. Was the process easy?
Someone has to be the first one.
I once registered web.site. I had it for a week or two before I tried pointing it at a server at which time someone noticed and took it off me.
Re: Track HN: Survival Rate of Show HN Stories
#48Is there a way to see how long a link stays on the hn front page on average, and if that average is rising or falling over time? I read that avg time spent by a twitter hashtag on the twitter trending page has been falling year over year. Indicating people's are paying less attention to any one thing.
Re: Track HN: Survival Rate of Show HN Stories
#49Earlier quoted context omitted.
How on earth did you get readme.com? I'm assuming someone else owned it, whenever I see that and all the "make an offer" links I move on and ignore it. Was the process easy?
Someone has to be the first one. I once registered web.site. I had it for a week or two before I tried pointing it at a server at which time someone noticed and took it off me.
“Someone”…?
Re: Track HN: Survival Rate of Show HN Stories
#50I'm happy to say that the reports of my death here are greatly exaggerated :) I'm the owner of both #4 and #140 on the Top-scoring Show HN Stories that Didn’t Survive... but both are very much alive! #4 StackSort was a Github.com page, but on 2021 they made it so only Github.io wroks. If dang sees this, I'd really appreciate if you could change the URL for https://news.ycombinator.com/item?id=5395463 to use github.io…
How on earth did you get readme.com? I'm assuming someone else owned it, whenever I see that and all the "make an offer" links I move on and ignore it. Was the process easy?
It wasn't called ReadMe originally... I happened to be browsing HN, and came across a post with someone offering readme.io for free, and I was like "oh that's a great name!" (I ultimately paid $3k as a thank you)
https://news.ycombinator.com/item?id=6397526
For the first few years, we used readme.io as our domain. When we did our Series A, I finally bought the .com for $170k. By that point I knew we were successful, and I figured the longer I waited the more it'd cost.