POSTGRES AS A SEARCH ENGINE

Summary from the TLDR Web Dev newsletter

PostgreSQL can be used as a search engine. Combining full-text search, semantic search with pgvector and fuzzy matching with pg_trgm makes PostgreSQL a good-enough search engine for a majority of use cases. This article goes into more advanced techniques to personalized search experiences, adjust for document length, debug rankings, and more.