Open monicabritton opened 6 years ago
Looking at various options. Use of tech like Xapian or SOLR seems a little heavy handed, and may require considerable code changes. Hoping that postgres can provide enough functionality. https://docs.djangoproject.com/en/1.11/topics/db/search/
Seems like this can only be solved with a combination of trigram, full text search, unaccent, and normal icontains filters if relying on Postgres functions. That will make things considerably more complicated and probably slower. More research is needed.
When searching for Labs, users (and other things) it would be useful for the search to be somewhat fuzzy, for reasons we discussed (non-English characters, etc). Perhaps picking up on at least 3 or 4 common characters between the search and the database. (Mike suggests looking at Xapian.)