I started to construct an app on Android using Firebase where users can post items to a live feed (recipes).
Everything was going great until I realized that as the number of posts grew, users would need a way to filter through all of the recipes.
For example, if they wanted to find all chicken dishes, they need to be able to search for chicken and see all recipes containing the word chicken.
The problem is that, as far as I can tell, you can only query for exact strings with Firebase. e.g. You can search for all recipes precisely titled "Chicken Parmesan" but you can't do a general search for all recipes containing the word "chicken".
Is there any way around this, or am I better off going for a relational DB setup?