User driven design pitfall. You ask the user what they want.
customer: "I want substring searches across all fields. Also you're going to use OpenSearch"
me: "That is going to be really slow, it would be slow for any DB stack. OS has these features, that's really all you can ask for"
customer: "I want substring searches and fuzzy searches. I also want to be able to specify exact matches on any field"
me: "That will make it unbearably slow and the other one requires a different database (SQL)"
Anyhow, when technology choices get made first, the user driven design should be: "Here is a menu of what features are possible, pick some or all of them."
♡ 0 ↻ 0