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: https://www.patreon.com/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/how-i-implemented-full-text-search-on-my-website

GiST and GIN Index Types (PostgreSQL)

https://www.postgresql.org/docs/9.1/textsearch-indexes.html

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