Company
Date Published
Author
Arun Gupta, VP, Developer Advocacy, Couchbase
Word count
2090
Language
English
Hacker News points
None

Summary

plain AWS Serverless Lambda Scheduled Events are used to store tweets in Couchbase. A few days into running, 269 tweets from @realDonaldTrump have been collected. The blog will analyze these tweets using N1QL, a SQL-like query language from Couchbase that operates on JSON documents. N1QL is used to find the top 5 tweeting days, tweet frequency, most common hour in a day to tweet, common day of the week to tweet, top 5 mentions in tweets, top 5 tweets with RTs, and most common words in tweets. The analysis shows that @realDonaldTrump tweets mostly on Tuesdays, has a high tweet frequency, uses many RTs, and frequently talks about media, fake news, and America in his tweets.