How to use textSearch to perform full text search - SupabaseTips

Learn more about Supabase 👇

[ricko]

Awesome 👌
full text search is such a basic yet important feature that every database should have.
Supabase +1 Firebase 0

[somegeneralist]

But why do this simple thing that takes 0 minutes when you can take hours to implement Algolia or ElasticSearch and set up functions to update your copy of your database on CRUD?! Jokes aside, this is awesome and it should give Firebase something to envy.

[axolotic]

Thanks! this is exactly what i need for my first project with SupaBase!

[vincentjohnflorio]

I had no idea it was so flexible with the ORs and quotations and minuses

[sillvvasensei]

Allow column to be comma separated so multiple columns can be searched. For example name and tags.

[jaksa]

how do i search by only part of a string for example if i search "jac" it returns a user with username "jackson" so that i dont have to type entire word jackson

[vincend]

How do you do this in an api request? I have some data in a table and i want to use an api get request to search for that information?

[khabbazz]

is superbase just for web application, or we can use it for android application?

[practical-skills-school]

Thank you. What about typos and guesses? Let's say, on "man saves worl" Google returnes "The Man Who Saved the World" despite a typo and altered verb tense.

[codingwithsolo]

This is super amazing, is there a sorting and filtering feature ?

[luizfernandonoschang]

For this to work it requires some kind of index on the database? What about the performance cost?

[rossanovinicius]

where I can find documentation about the other languages available?

[sourabhsahu]

text searching is not working if we pass partial text

[dongums]

can i use full text search for mutiple columns?

[SuperMaDBrothers]

collab with algolia and you have something useful. noone uses full text search.