4 ms·

Why not create periodic dumps of the database and allow people to glean interesting statistical data from it? You could remove any non-public information (passw

by kylec 18y ago

Why not create periodic dumps of the database and allow people to glean interesting statistical data from it? You could remove any non-public information (passwords, preferences, individual up/down voting, last 2 octets of the IP, etc). It would be interesting to see what hours and what days people are active, where the visitors are coming from, what the most common words used are, etc.

boredguy8 18y ago
Like http://news.ycombinator.com/item?id=172701 http://news.ycombinator.com/item?id=172701 http://news.ycombinator.com/item?id=182374 http://news.ycombinator.com/item?id=182374 http://news.ycombinator.com/item?id=197644 http://news.ycombinator.com/item?id=197644 http://news.ycombinator.com/item?id=212491 http://news.ycombinator.com/item?id=212491 http://news.ycombinator.com/item?id=213891 http://news.ycombinator.com/item?id=213891 ? http://news.ycombinator.com/item?id=218782 http://news.ycombinator.com/item?id=218782
- andreyf 18y ago
  The data you can gather from crawling the site aren't as specific as the data in the database. For example - you don't know the exact submission times of older pieces, only the day.
  - chengmi 18y ago
    That information can be derived from multiple observations.
trevelyan 18y ago
Maybe because it's too much work.