PostgreSQL Full Text Search Tutorial

День тому

Let's take a look at Postgres full text search and how it works. I think this is the quickest way to get started with full text search! Hope you enjoy.
Useful Links:
Docs: www.postgresql.org/docs/curre...
Music:
• Play It Again, Sam
Huge thank you to Harris Heller for providing copyright-free music.
Hey everyone! My name is Redhwan Nacef (Red for short). In this channel, I'm hoping to share my thoughts on software engineering, coding, management, and all things tech. I hope you enjoy!

КОМЕНТАРІ: 19

@knightblanc4413 7 місяців тому

Great job man!! ❤

@cgeyer 7 місяців тому

great synopsis, thank you!

@michel-814 2 місяці тому

Excellent ! Short, concise ... really clean explanation. Thanks

@umitdemir3741 6 місяців тому

that's a really good explanation. Thank you for making this video.

@sohaybelgendy4919 3 місяці тому

Thank you man!

@ervamate 5 місяців тому

Great intro!

@TheYidoify 15 днів тому

Thank you!

@ulissescruz5540 6 місяців тому

great video

@wizzl8513 8 місяців тому

Great explanation, thanks!

@RedhwanNacef 8 місяців тому

Glad you enjoyed it!

@indreiuflavius2240 2 місяці тому

what is the song from intro? 🔥

@Anto-mi5pn Місяць тому

What's the SQL editor you're using?

@ngoclinhvu5381 4 місяці тому

What coding IDE are you using?

@TeaJayOne 2 місяці тому

Looks like rider with a theme.

@SAMEERSHAIKH-dw8rg 6 місяців тому

What if i want to join multiple tables and perform search on those columns

@jeyfus 4 місяці тому

You can join the tables and build ts_vector with columns from whatever tables you’d like to search on. Just like in the video when he references name or description, it could have been table1.name and table2.description if they were in two different tables that you joined.

@SAMEERSHAIKH-dw8rg 4 місяці тому

@@jeyfus thanks

@kennethkentan3961 5 місяців тому

10:56 on my end, line 68 didn't seem to utilize the index on line 76. Because the index on line 76 is using to_tsvector('english', document), I had to match that as well in the WHERE clause in line 68. WHERE TO_TSVECTOR('english', document) @@ WEBSEARCH_TO_TSQUERY('thor')