My use case is suppose I have 7 attributes/columns and I have to do multiple queries where each query will include 2 or more columns like if column 1 value is A and column 2 value is B fetch the rows which satisfies this query.
Firstly I have considered DynamoDb but I have to create many GSIs to satisfy this use case and noticed this causes higher writes cost and latency and only gives eventual consistency.
Secondly, I have explored DynamoDb with OpenSearch where we can perform all these queries in OpenSearch.
Thirdly, using Aurora RDS.
I want to see which of these fits best for my use case and why.
SSR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.