Postgres full-text search is Good Enough!

Created on 2023-02-13T03:09:58-06:00

Concatenating all searchable fields to a single large string
Using `to_tsvector` function to convert the long string in to a word vector for search
Using `@@` to match a tsvector against a query
Using `ts_rank` to obtain a relevance score for a query against a document and sorting by document relevancy
Using `pg_trgm` to create trigrams out of search terms in documents. Trigrams are then used to detect misspelled words.