I've been through several forum deaths. The cause is usually large growth from people with very different mindsets that downvote for essentially political reasons instead of encouraging good discourse. This makes the best people leave in short order. In a sense there's no way to structure a forum to avoid this. Being outnumbered by people who don't value open communication is unpleasant with or without downvoting. Fo…
Would actually like to see a list of largest karma-wise HN members who left. By leaving I would say over 180 days inactive. Dang can you post the result please: SELECT hn_name, hn_karma, hn_last_active FROM comments WHERE TIMESTAMPDIFF(DAY, hn_last_active, NOW()) > 180 ORDER BY hn_karma DESC LIMIT 100
Ah, Hacker News is too cool to use something as pedestrian as a database ;)
But there is a Google BigQuery dataset[0,1]. I don't know how up to date it is.
[0]https://console.cloud.google.com/bigquery?p=bigquery-public-...