3 ms·
This looks great. How does it work - are you scraping this data or using an API?
by ksrm 9y ago
This looks great. How does it work - are you scraping this data or using an API?
- russellbeattie 9y agoI 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.