- Joined
- Jan 4, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 1
When doing a recipe search, a nice feature would be the ability to set min and max values for ABV and IBU. It may requiring adding an index on those fields to optimize the DB, but you may already have one since I can sort by both fields. I am not sure what backend you use, but an additional WHERE clause like
Forgive the lame pseudo code and over generalizations, but looking for a good starter recipe with an IBU less than 35 in the color I was looking for took me 45 minutes since i was unable to limit my search to what I was looking for. Something like this may be a useful feature in these situations.
Code:
SELECT * FROM recipes WHERE recipe.ibu < request.max_ibu AND recipe.ibu > request.min_ibu
Forgive the lame pseudo code and over generalizations, but looking for a good starter recipe with an IBU less than 35 in the color I was looking for took me 45 minutes since i was unable to limit my search to what I was looking for. Something like this may be a useful feature in these situations.