BUGS-NYU/schedge

Fix search

A1Liu opened this issue · 1 comments

A1Liu commented

Bruh it's been utter garbo for so long it needs to NOT be garbo

just fix it with the not-garbo button bro it's so easy

The first implementation was done in StackOverflow-Style, where I just copied random shit from the postgres docs until it worked-ish. This time, I'm going to really actually read the docs before implementing it.

Needs:

  • Don't crash lol
  • Faster speeds using generated columns and indices on those columns
  • Weights on the data fields that makes the search return better results more often
  • Partial word searches, or at least some kind of fuzziness
  • Do some query profiling to get the latency lower; still slow in prod
  • Do some more profiling; requests are still ~100ms
A1Liu commented

Going to close this, as Schedge v1 search in production right now times at ~150ms, so the current v2 time of ~75ms is OK enough to not block v2 beta release

The unfinished stuff from above is separated into another issue.