I would like to create a database to store how often access tokens in my system are being used.
I was thinking of a data model like so -
- Access Token
- from (basically I will store this hourly, so this will be the timestamp of the start of the hour)
- Number of times used
What would be the ideal database for this? I am conflicted with several choices.
Some more details to help out:
- We get around 5k requests per minute, so the DB will have to be quick enough to update that.
- We will not often be querying the database, probably only be looking for daily summaries and month end aggregations for accounting and auditing purposes.
- We would prefer this to be on AWS as a service, but we can also spin up instances on our own.