Does anyone know how I can configure a robust and clean search function in supabase? I'd like to configure a search so that it can search multiple fields in a table for a search term and return exact or partial matches. Currently there is exactly one (1) tutorial on this topic, and it's extremely amateurish and incomplete. As far as I can tell, FlutterFlow documentation overlooks the need for this entirely..
My current configuration makes an api call that returns uuids, and then i have a backend query that queries rows containing the uuids from the search result. However, this seems pretty clunky, it's slow, and throws an error when the search results are too specific and only returns one or no matches. Obviously this is not practical for a working application.
Anyone have any solutions? I would really love to avoid having to shell out for Algolia. Really appreciate it.