Provide Your Recommendation of Database. 10 minute consulting (NoSQL vs SQL)
Budget: $10 – $30 USD
I need a recommendation for a database solution and the setting up of database schema for a mobile app with features similar to a dating app. So searching through many complex user objects is essential.
For example, each user will have various sorts of traits that can be searched and filtered against each other like Personality type, body type, category, gender, style, birthday, location etc.
I'm mostly concerned with scaling because user profiles have a lot of potential traits, and custom tags. If there are 1M users I want the best solution for filtering through traits and custom tags of all users.
There are 4 traits and each trait has 10-20 options. In addition to that, one of the traits would be a custom tag entered by the user. So if I use something like Firebase I don't want it to get too expensive over time, or too slow with self-hosted.
So the database has to be set up in a way that it's quick to search and filter all multiple traits and tags. Must be able to scale and work with potentially millions of users. We are using flutter for the front end so if there's a solution that works great with that, then better.
For example, each user will have various sorts of traits that can be searched and filtered against each other like Personality type, body type, category, gender, style, birthday, location etc.
I'm mostly concerned with scaling because user profiles have a lot of potential traits, and custom tags. If there are 1M users I want the best solution for filtering through traits and custom tags of all users.
There are 4 traits and each trait has 10-20 options. In addition to that, one of the traits would be a custom tag entered by the user. So if I use something like Firebase I don't want it to get too expensive over time, or too slow with self-hosted.
So the database has to be set up in a way that it's quick to search and filter all multiple traits and tags. Must be able to scale and work with potentially millions of users. We are using flutter for the front end so if there's a solution that works great with that, then better.