In general I'm following this quick start from supabase: https://supabase.com/docs/guides/database/full-text-search
-
I'm using Lexical (https://lexical.dev/) for my text editor and savign data as JSON, so I can't use the data from Lexical for searching. Saved text looks like this:
-
I created additional column for storing the raw strings from Lexical with additional values from other inputs in my form (location, company name, offer title, etc..)