I would like to keep track of about 10 million username/country pairs daily and track changes. So I will run my code once a day and would like to efficiently have a history of country info for each username. If I was running this on my local computer, I can make a simple sqlite database and track accordingly. But this project requires a bit more robust approach where I will be continuously run the code on an EC2 instance and update the database. I was reading on DynamoDB, S3 etc and cannot figure out what is an expert programmer’s approach to this situation.

So far it is in the development stage, I typically use the sqlite3 library on python, but as remarked before, I am trying to move to cloud.