Question 337059 in Amazon Web Sevices Question posted in
The official Amazon Web Services documentation can be found here.

Amazon web services – What is the best AWS service to store small amount of data

I have a use case where I need to store some data (just a few hundreds) of records with just one column (a string similar to a UUID) and timestamp.
Also I need to have an efficient way to avoid duplicates of the main column (not the timestamp) and perform reads/writes/deletes frequently.

I’m currently using an RDS database but it seems overkill for this.

Using AWS services what would be the best way, taking in consideration that performance and cost are important.

Tags:

2

Answers


  1. 0

    Consider Amazon MemoryDB, probably the best options you can get for price/performance if you have tiny data set. Because it’s im-memory db, it’s really fast and low latency and you won’t pay much for one instance cluster with smallest Node type.

    Another option can be Aurora Serverless if you want regular RDS, depends on your usage pattern in the end of the day might be more expensive option.

    Login or Signup to reply.
  2. 0

    Frankly, you could just use Amazon S3.

    Think of it as a NoSQL database:

    • The Key is the Key of the object (which guarantees uniqueness)
    • The Value is the content of the object

    You could do fancy stuff Filtering and retrieving data using Amazon S3 Select – Amazon Simple Storage Service, but frankly I’d suggest you just read the whole object and parse it in your code. It sounds like your items would be small enough to keep in memory.

    To update information in the object, just PUT the whole object again with the updated information. It would be very fast since your data would be kept in memory within your app.

    The only issue would be if you have simultaneous updates of the data due to parallel-running of the application.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search