Creating a search catalog in PostgreSQL using full text indexing
Переглядів 9,604
День тому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...
@pramodjingade6581 3 місяці тому
I learnt all that I needed for search in just 14 mins, thanks to this video. 💯 to keep it simple & easily understandable!! 👍
@Misa7531 3 місяці тому
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!
@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.
@Koshick Рік тому
Wow this is really awesome tutorial. Thanks for your detailed instructions.
@llgmusic Рік тому
Thanks for this tutorial, it's very helpful and comprehensive! IT gives me some arguments to use Postgres as a database
@billy_azzztec Рік тому
Thank you!
@carloscampos7709 Рік тому
Great video. Thanks!
@lucianostegun Рік тому
Awesome video! Learned a lot!!!
@ralphlewis3563 Рік тому
I Love this. Awesome and to point
@muralikrishnaabcdefg 7 місяців тому
god gifted child❤. saviour is small word
@pedestrian9287 Рік тому
Terrrrrific video!! Exactly what I needed!
@silasselfe5308 Рік тому
you've earned my subscription.
@ndevadas Місяць тому
Thank you
@MatteoPresot Рік тому
really no words other than thank you!!
@blameItleaveit 11 місяців тому
awesome video
@Septumsempra8818 5 місяців тому
Top Video!!! How do we do this for ecommerce? So product names, cats etc, and also sortings on price, and lastly pagination. 🇿🇦
@TheProtein83 Рік тому
Terrific info! I am curious to know how this setup compares with elastic search for full text search?
@kasvith Рік тому
Subbed immediately
@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!
@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.
@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 :)
@billy_azzztec Рік тому
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.
@big-machine Рік тому
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.
@billy_azzztec Рік тому
@@big-machine Ok gotcha. Thank you!
@1337shadow Рік тому
M waiting for my borito
@Justinallenmarsh 3 місяці тому
Is this search fuzzy?
@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,
@doridore1234 Рік тому
i better get that fuckin burrito.
@gadgetboyplaysmc 8 місяців тому
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.
HighLoad Channel
Переглядів 12 тис.
The Magic of SQL
Переглядів 28 тис.
JPoint, Joker и JUG ru
Переглядів 38 тис.
KOMPUKTER
Переглядів 166 тис.