All threads / What database should I use?

Ask A Question

Notifications

You’re not receiving notifications from this thread.

What database should I use?

Michael Victor asked in Databases

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 teh 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 -

  1. We get around 5k requests per minute, so the DB will have to be quick enough to update that.
  2. We will not often be querying the database, probably only be looking for daily summaries and month end aggregations for accounting and auditing purposes.
  3. We would prefer this to be on AWS as a service, but we can also spin up instances on our own.
As Solomon David said MongoDB is one of the NoSQL database. Currently there are 150 of them (NOSQL Databases). It falls into the document store category. These categories are defined based on architecture of particular database. Most of the NoSQL databases came out of need to tackle complex storage problems. For example, Cassandra was designed by Facebook to power their inbox search feature. mongodb training in chennai
Join the discussion

Want to stay up-to-date with Ruby on Rails?

Join 37,629+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    logo Created with Sketch.

    Ruby on Rails tutorials, guides, and screencasts for web developers learning Ruby, Rails, Javascript, Turbolinks, Stimulus.js, Vue.js, and more. Icons by Icons8

    © 2020 GoRails, LLC. All rights reserved.