Creating a search catalog in PostgreSQL using full text indexing

Creating a full text index in PostgreSQL is an extremely powerful way to add a full-featured, comprehensive search function to your application. Full text indexing is probably the most under-appreciated feature of PostgreSQL, but it's there and you can take advantage of it!
The code and data is here: bigmachine.io/2022/06/12/crea...
Postgres resources: bigmachine.io/products/a-curi...

[@adamroach43]

amazingly helpful and well communicated. thank you!

[@pramodjingade6581]

I learnt all that I needed for search in just 14 mins, thanks to this video. 💯 to keep it simple & easily understandable!! 👍

[@olebogengmauco1297]

Thank You for show us the light. I've subscribed, instead of making me a borito, want to come to your house and make you a borito 😁🙏

[@juanalbertoboada]

Hi Rob, Amazing video on Full Text Search on Postgresql (I am pretty new to postgresql butI have experience on other SQL engines). I am following the knowledge from you video, I will let you know if I could implement the FTS on my project. JB

[@carta-viva]

Oh Lord, I'd to work with Postgres again u.u, but whait, how cool is that? It's awesomeness cool! Thanks for sharing this Mr Rob!

[@Misa7531]

That was amazing, I didn't even realize that something like this is possible this video definitely goes to "bookmarks" for future reference , thank you very much.

[@SpecialK845]

This has changed my life. Thanks for the video!

[@oubayryuuk]

im loving these vids, pls keep on making them

[@bricef0918]

Awesome tutorial! Very well explained. Thank you!

[@llgmusic]

Thanks for this tutorial, it's very helpful and comprehensive! IT gives me some arguments to use Postgres as a database

[@Koshick]

Wow this is really awesome tutorial. Thanks for your detailed instructions.

[@naufalamiruddin5798]

Great tutorial! very clear and detailed explanations. You deserve more subscriber sir.

[@zed9zed]

Amazing video. You really pack a lot in, but with adequate explanations (and some humor that thankfully does not get in the way). I may have to watch this 5 times to get it all, but that's better than having to watch a video on fast forward and 10sec jumping frequently to skip over fluff.

[@ndevadas]

Thank you

[@lucianostegun]

Awesome video! Learned a lot!!!

[@carloscampos7709]

Great video. Thanks!

[@ralphlewis3563]

I Love this. Awesome and to point

[@pedestrian9287]

Terrrrrific video!! Exactly what I needed!

[@silasselfe5308]

you've earned my subscription.

[@blameItleaveit]

awesome video

[@kasvith]

Subbed immediately

[@TheProtein83]

Terrific info! I am curious to know how this setup compares with elastic search for full text search?

[@Septumsempra8818]

Top Video!!! How do we do this for ecommerce? So product names, cats etc, and also sortings on price, and lastly pagination. 🇿🇦

[@soumenkhara5456]

This video is awesome. Can you explain same thing in multiple releted table?

[@big-machine]

I would say to denormalize and have a dedicated search table that gets updated automatically, or via code.

[@microtech2448]

Great video! Nice way of explanation. One thing, can it handle fuzziness too?

[@big-machine]

See the comment below RE fuzziness from @Rocco - fuzzy queries and text queries are different beasts. If you want fuzziness, use the ~* operator (regex) but be mindful of destroying your indexes!

[@dasR0ckt]

Hi, I tried to take a look at the data you mentioned in the video and play around a bit, I cant find it behind the link in the description though. Am I being thick and overlooking something? Thanks for the video, I never knew about full text search.

[@big-machine]

Whoops - looks like I left the link out! I added it back if you're still up for trying things out: bigmachine.io/2022/06/12/creating-a-full-text-search-engine-in-postgresql-2022/

[@dasR0ckt]

@@big-machine Thanks, thats awesome :) I found a (german) quote database in the meantime too, lets see if the things I did with that work out just as well with yours :)

[@deer7183]

how can you add synonyms like if someone searches 'bag' it should also show 'backpack' results?

[@big-machine]

You would probably need to do this yourself using code - but even then you're skewing the context. Backpack is a verb and a noun and is it really a bag? I know you're just giving an example - but these are the kinds of things you need to think through in terms of lexxing,

[@1337shadow]

M waiting for my borito

[@Justinallenmarsh]

Is this search fuzzy?

[@doridore1234]

i better get that fuckin burrito.

[@gadgetboyplaysmc]

I am overwhelmed. Not the best at SQL at all. How'd you learn all this? If you could give a roadmap on learning Postgresql features like this from scratch it would be great if you could share. Time to watch this video 20 times until I get it.

[@MatteoPresot]

really no words other than thank you!!