I’m trying to set up a periodic crawl for terms of interest to see if communities pop up that discuss them. Some are easy, like “Mordhau” because no other words contain it. On the other hand, “sword” and “HEMA” are problematic because things like “password” and “mathematical” contain them.

I tried to put quotes around the string but that returns nothing, and padding a space on either side didn’t change results.

    • Ken Oh@lemm.eeOPEnglish
      3·
      1 year ago

      Ah thanks, that does look very much on the crawl side of crawl-walk-run. Hopefully the devs understand the urgency of discoverability.

    • kevincox@lemmy.mlEnglish
      1·
      1 year ago

      It’s amazing how far a table scan will scale. But yes, I think replacing this by PostgreSQL Full Text Search will probably need to be done sooner than later.

      This will give some benefits such as stemming but will have some tradeoffs such as only allowing searching by full words. (but for Lemmy this is probably what people want 99% of the time.)

    • Ken Oh@lemm.eeOPEnglish
      2·
      1 year ago

      @heartlessevil@lemmy.one linked to the source, looks like there’s no way at the moment. Let’s hope that changes soonish.