Add full text search vector to postgresql

It would be nice to have a full text search on the database. Mainly for searching pseudonym, but it could be used for datapod specialized about marketplace by example. It could search for products.

Full text search mean searching the term manutopic return ManUtopiK as a result. It implements approximative result for better UX.

There are a plenty way to provide full text search. With a custom function with to_tsvector, or via pg extension.

Here are some useful links :

• https://lantern.dev/blog/text-search
• https://anyblockers.com/posts/postgres-as-a-search-engine
• https://blog.brendanscullion.com/postgresql-text-search#heading-performance-improvements
• https://www.crunchydata.com/blog/fuzzy-name-matching-in-postgresql

ParadeDB looks awesome : https://github.com/paradedb/paradedb/tree/dev/pg_search

My stars about database : https://github.com/stars/ManUtopiK/lists/db