News for hackers. Stuff that matters.

A comment on A proposal to improve Twitter and perhaps the world. Parent comment

Re:A proposal to improve Twitter and perhaps the world by russellbeattie on Tuesday March 06, 2018 @03:54PM (#16532028)
I use the official API to fetch the tweets every 15 minutes, then it filters and saves each tweet individually into a flat database table. This view gets the tweets via JSON using a simple SQL query that groups and sorts by user, filtering for the past x hours.
[ Parent | on HN ]

There are no comments on this comment yet.