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 tw

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.