should i use supabase text search or algolia?

I need a basic varchar text search for finding rows from my db. There's textSearch option in supabase

33 Replies

100% don't use a second database if you don't need one. The supabase text search is definitely sufficient for most needs. - https://code.build/p/6KPQqmE2wsVdYaRZiAVDzF/supabase-fuzzy-full-text-search

Supabase Fuzzy Full Text Search - Code.Build

Full Text Search Postgres supports many full-text search options. Your options include:- [LIKE](https://www.postgresql.

NistharOP•3y ago

i did this

NistharOP•3y ago

NistharOP•3y ago

any idea why its not working?

NistharOP•3y ago

i am getting this as the result

jdgamble555•3y ago

are you using sdk v2?

NistharOP•3y ago

    "dependencies": {
        "@supabase/auth-helpers-sveltekit": "^0.7.1",
        "@supabase/supabase-js": "^1.35.7",

    "dependencies": {
        "@supabase/auth-helpers-sveltekit": "^0.7.1",
        "@supabase/supabase-js": "^1.35.7",

this is the version i am using i think its the latest version

jdgamble555•3y ago

It works with certain queries? I am using the RC v2 js sdk, so not sure if that matters here

NistharOP•3y ago

wdym certain queries? the normal selects, inserts works fine

jdgamble555•3y ago

so what doesn't work?

NistharOP•3y ago

this one

jdgamble555•3y ago

So the query "cet g" does not work? but everything else does?

NistharOP•3y ago

yeah only the textSearch function is not working its the text i am searching for nope still not working

NistharOP•3y ago

i think spaces are not working are you using spaces in your phrases?

jdgamble555•3y ago

try .textSearch('title', query, { type: 'phrase' });

NistharOP•3y ago

it works but its not returning anything

NistharOP•3y ago

i have this in my table even typing the whole thing doesn't return anything

jdgamble555•3y ago

does 'cet' work?

NistharOP•3y ago

jdgamble555•3y ago

what does your full query look like in js?

NistharOP•3y ago

like this

jdgamble555•3y ago

I'm wondering if you need to make the varchar a text field, or if you need to add an index like this:

CREATE INDEX groups_index ON public.groups USING gin (to_tsvector('simple'::regconfig, name))

CREATE INDEX groups_index ON public.groups USING gin (to_tsvector('simple'::regconfig, name))

or similar I honestly have no idea at this point, this should work unless it is one of those two things... Or you're leaving something out... oh, change to.select('*')... see if that helps

NistharOP•3y ago

I tried adding a text column for testing Its the same

jdgamble555•3y ago

try creating an index on it, not sure if that is necessary supabase js sdk uses postgrest under-the-hood, so not sure if this can help you - https://postgrest.org/en/stable/api.html?highlight=full%20text#full-text-search

NistharOP•3y ago

Thanks man! It was a stupid mistake on my part

jdgamble555•3y ago

What was it?

NistharOP•3y ago

its not fixed yet i thought it was the rls but it wasn't ok its fixed now it was a combination of some other things like rls, filters Thanks again!

Gaming

Programming

should i use supabase text search or algolia?

Did you find this page helpful?