Just playing around with postgres search capabilities. Using a combination of full text search and similarity search.
Resources:
- https://www.postgresql.org/docs/current/textsearch-intro.html
- https://www.postgresql.org/docs/current/pgtrgm.html
- https://supabase.com/blog/postgres-full-text-search-vs-the-rest
- https://www.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database
- https://leandronsp.com/a-powerful-full-text-search-in-postgresql-in-less-than-20-lines