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.
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.
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
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!
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.
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/
@@rconery 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 :)
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,
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.
I learnt all that I needed for search in just 14 mins, thanks to this video. 💯 to keep it simple & easily understandable!! 👍
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.
This has changed my life. Thanks for the video!
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!
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.
Great tutorial! very clear and detailed explanations. You deserve more subscriber sir.
Thanks for this tutorial, it's very helpful and comprehensive! IT gives me some arguments to use Postgres as a database
im loving these vids, pls keep on making them
really no words other than thank you!!
Terrrrrific video!! Exactly what I needed!
amazingly helpful and well communicated. thank you!
you've earned my subscription.
Wow this is really awesome tutorial. Thanks for your detailed instructions.
Awesome video! Learned a lot!!!
I Love this. Awesome and to point
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
Awesome tutorial! Very well explained. Thank you!
Top Video!!!
How do we do this for ecommerce? So product names, cats etc, and also sortings on price, and lastly pagination.
🇿🇦
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 😁🙏
Great video. Thanks!
Terrific info! I am curious to know how this setup compares with elastic search for full text search?
This video is awesome. Can you explain same thing in multiple releted table?
I would say to denormalize and have a dedicated search table that gets updated automatically, or via code.
Thank you
Great video! Nice way of explanation. One thing, can it handle fuzziness too?
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!
awesome video
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.
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/
@@rconery 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 :)
how can you add synonyms like if someone searches 'bag' it should also show 'backpack' results?
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,
Is this search fuzzy?
Subbed immediately
Waiting for my burito that you promised
M waiting for my borito
i better get that fuckin burrito.
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.