Re:A proposal to improve Twitter and perhaps the world
by ksrm on Tuesday March 06, 2018 @03:09PM
(#16531644)
This looks great. How does it work - are you scraping this data or using an API?
[ Parent
| on HN ]
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.