↓ Ir para o conteúdo principal

← todas as notas

🖼 Comic

You can do full-text search in Postgres?

Community post by Milan Jovanović (@MilanJovanovicTech) on YouTube. Post.

You can do full-text search in Postgres? 🐘

Yes — and you can even wire it up with EF Core.

With this, you can:

  • Set up full-text search indexes
  • Write efficient search queries
  • Rank and sort results by relevance
  • Integrate it smoothly inside your .NET apps

Want a clean architecture foundation to plug these features into?

P.S. Grab my Clean Architecture template here: https://www.milanjovanovic.tech/templates/clean-architecture

What Postgres features have surprised you the most?

Code card “Full-text Search with Postgres + EF Core”: a C# query over db.Articles filtering with EF.Functions.ToTsVector(“english”, title plus content).Matches(EF.Functions.PlainToTsQuery(“english”, searchTerm)), then printing each article’s Id and Title.