Search Advice
Hi, I have a table called profiles that has several fields Name (str), Username (str), Email (str), Rank (int), Tags (array(str)), Age (int), Gender (str), etc...
I want to be able to do full text search and typeahead while being able to filter and sort on name (a-z, z-a), username (a-z, z-a), rank (low-high, high-low), tags (filter by specific tags), age (range, high-low, low-high), gender (filter by Male, Female, Non-binary, etc...)
I have about 500k profiles and growing, I want some advice on how I would efficiently query this table with my needs.
Thanks!
I want to be able to do full text search and typeahead while being able to filter and sort on name (a-z, z-a), username (a-z, z-a), rank (low-high, high-low), tags (filter by specific tags), age (range, high-low, low-high), gender (filter by Male, Female, Non-binary, etc...)
I have about 500k profiles and growing, I want some advice on how I would efficiently query this table with my needs.
Thanks!
