Creating a search catalog in PostgreSQL using full text indexing
HTML-код
- Опубликовано: 13 июн 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... 
Наука
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!
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.
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 has changed my life. Thanks for the video!
Great tutorial! very clear and detailed explanations. You deserve more subscriber sir.
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.
Awesome tutorial! Very well explained. Thank you!
im loving these vids, pls keep on making them
Thanks for this tutorial, it's very helpful and comprehensive! IT gives me some arguments to use Postgres as a database
Wow this is really awesome tutorial. Thanks for your detailed instructions.
Awesome video! Learned a lot!!!
Terrrrrific video!! Exactly what I needed!
I Love this. Awesome and to point
you've earned my subscription.
Great video. Thanks!
Thank you
Thank you!
awesome video
Subbed immediately
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.
🇿🇦
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!
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.
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 :)
I've already added it to my database and everything else works as expected! This is awesome, but can I make it a little more fuzzy? For example, if I search for the name "Jessica West" both "Jessica" and "West" will return the whole string, but "Jessic" or "Wes" do not.
Fuzzy search is a lot different than full text - I suppose think of searching Google for "Jessic" - what would you expect to find? I *do* think there are some ways to do intelligent fuzzy searching - but if that's what you need than a regex is your best bet (~* 'Jessic'), even if it scales horribly.
@@big-machine Ok gotcha. Thank you!
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
really no words other than thank you!!
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.