About fuzzy search, do you feel ok about the performance? I had a general feeling that for that type of stuff you need a dedicated search thingy, maybe elastic search?
About fuzzy search, do you feel ok about the performance? I had a general feeling that for that type of stuff you need a dedicated search thingy, maybe elastic search?
About the search part, imagine that in busy days we'll have at most 2-3K active deals, therefore Postgres can do the job really fine with that amount of data. Elastic search was in the table but I think it would be overkill for my use case. Also by having 100% indexable queries performance impact is small. PG provides a lot of goodies to get the job done.
You can try to play with it, just type an english word in the search bar eg "game" and then "geme"
[0] https://translate.google.com/translate?sl=el&tl=en&u=https%3...