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
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 :)
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!
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.
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!
This has changed my life. Thanks for the video!
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
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
really no words other than thank you!!
Terrrrrific video!! Exactly what I needed!
amazingly helpful and well communicated. thank you!
Wow this is really awesome tutorial. Thanks for your detailed instructions.
Top Video!!!
How do we do this for ecommerce? So product names, cats etc, and also sortings on price, and lastly pagination.
🇿🇦
you've earned my subscription.
I Love this. Awesome and to point
Awesome video! Learned a lot!!!
Awesome tutorial! Very well explained. Thank you!
Terrific info! I am curious to know how this setup compares with elastic search for full text search?
Great video. Thanks!
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 😁🙏
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.
Is this search fuzzy?
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 :)
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
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,
Thank you
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.