Full Text Search in .NET With PostgreSQL and EF Core

Want to master Clean Architecture? Go here: https://bit.ly/3PupkOJ
Want to unlock Modular Monoliths? Go here: https://bit.ly/3SXlzSt
Join a community of 1000+ .NET developers:   / milanjovanovic  

Learn how to implement powerful full-text search capabilities in your .NET applications using PostgreSQL and Entity Framework Core. This tutorial will guide you through setting up full-text search indexes, writing efficient search queries, and integrating them seamlessly with EF Core. Discover how to leverage PostgreSQL's advanced text search features to enhance your application's search functionality.

How I Implemented Full-Text Search On My Website
https://www.milanjovanovic.tech/blog/...

GiST and GIN Index Types (PostgreSQL)
https://www.postgresql.org/docs/9.1/t...

Check out my courses:
https://www.milanjovanovic.tech/courses

Read my Blog here:
https://www.milanjovanovic.tech/blog

Join my weekly .NET newsletter:
https://www.milanjovanovic.tech

Chapters
0:00 Simple EF Core search
3:54 Normalizing search terms
7:10 Postgres full-text search (GIN index)
12:33 Ranking search results by relevance
16:01 EF Core + Npgsql alternative
20:45 Boosting search terms (weighted search)
21:48 Full-text search on my website, Lunr.js