← Back to Upcase

What database should I use?

(Michael Kevin Victor) #1

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.