I'm going to develop a simple application for my personal use. Since RDS is costly 15$ per month, I'm thinking of using DynamoDB as it's always free. My data size won't grow beyond 25GB as provided in the specs (It won't even cross 1Gb) My question is, 1. Will Amazon dynamo DB always be a free tier? in the future?
You can’t do everything that you can do with an RDS with Dynamo. They are two different beasts for different use cases. But if your data is very small and you have a single column as a key that you always use to access data - dynamo does it to store but you still can’t query the data like you can do with RDS. So you go with a key and you can retrieve a json body that you need to parse.
Lol DynamoDB has a shit load of issues and no one should use it for anything production facing with more than 10,000 users
I'm the only user
It will probably be free forever and your use case GSIs use up a lot of quota fast Also, scanning should almost never be done unless table < 1000 Use Partition/sort key as primary data access first, trying to hack GSIs and indices will leave you in a world of hurt