Live data from Hacker News

Track HN: Survival Rate of Show HN Stories

nami.land

31–40 of 75 posts

Re: Track HN: Survival Rate of Show HN Stories

#34
post #24

Nice work! I'd actually be interested in factors that make a Show HN a success vs failure. Objectively, there's an obvious one your dataset: time of submission. Tuesday afternoon (which timezone? I assume US west coast?) seems to be key. No way this correlates with the quality of submissions. Subjectively: it seems to become much harder recently. I managed once a couple of years ago for a short time to reach the fron…

Its badge on a product's home page is to me a negative signal, but partly since it does still happen (quite a lot) - people do seem to use ProductHunt.

(I suppose I'd use it - and pretty much anything - but just not put 'omg #1' badge on my site, if I had something to launch myself.)

Completely tangential now, but I think its problem is right in the title - who is hunting a product? It's a complete echo chamber, surely nobody who doesn't have something to launch is actively using it - 'it's Wednesday so I need a new Gmail-integrating Jira spline reticulator'.

Re: Track HN: Survival Rate of Show HN Stories

#36

I'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…

The main page https://gkoberger.github.io/ that the https://gkoberger.github.com/ link suggests going to gives a 404 as well. Could be a good idea to add a main page for https://gkoberger.github.io/ that links the StackSort page and anything else

Re: Track HN: Survival Rate of Show HN Stories

#37
> 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 Air.

Here is the database with publicly available SQL endpoint: https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...

Re: Track HN: Survival Rate of Show HN Stories

#38
post #14
post #7

Regarding database hosting, if you would consider giving the data away, I would suggest converting it to an SQLite database and sharing it over Torrent.

I second this. You've done a great service to collect this data. I'm guessing the file must be much smaller than 20GB when compressed.

It is only around 5 GB in ClickHouse. Details: https://github.com/ClickHouse/ClickHouse/issues/29693

Re: Track HN: Survival Rate of Show HN Stories

#39
post #14
post #7

Regarding database hosting, if you would consider giving the data away, I would suggest converting it to an SQLite database and sharing it over Torrent.

I second this. You've done a great service to collect this data. I'm guessing the file must be much smaller than 20GB when compressed.

I've also did an experiment by generating and searching embeddings for all the comments on HN. Here is the walkthrough: https://www.youtube.com/watch?v=hGRNcftpqAk

Re: Track HN: Survival Rate of Show HN Stories

#40

I'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?

Post reply on HN