Creating a search catalog in PostgreSQL using full text indexing
Вставка
- Опубліковано 23 лип 2024
- 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... - Наука та технологія
amazingly helpful and well communicated. thank you!
I learnt all that I needed for search in just 14 mins, thanks to this video. 💯 to keep it simple & easily understandable!! 👍
This has changed my life. Thanks for the video!
im loving these vids, pls keep on making them
Awesome tutorial! Very well explained. Thank you!
Thanks for this tutorial, it's very helpful and comprehensive! IT gives me some arguments to use Postgres as a database
Great tutorial! very clear and detailed explanations. You deserve more subscriber sir.
Wow this is really awesome tutorial. Thanks for your detailed instructions.
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.
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 😁🙏
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.
I Love this. Awesome and to point
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!
Awesome video! Learned a lot!!!
Great video. Thanks!
Terrrrrific video!! Exactly what I needed!
Thank you
you've earned my subscription.
awesome video
Terrific info! I am curious to know how this setup compares with elastic search for full text search?
Top Video!!!
How do we do this for ecommerce? So product names, cats etc, and also sortings on price, and lastly pagination.
🇿🇦
Subbed immediately
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.
really no words other than 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!
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/
@@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 :)
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?
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.