Postgres SQLAlchemy Textbook Ch. 4 — Full-Text Search
Practical full-text search in Postgres via SQLAlchemy: tsvector, GIN, websearch_to_tsquery, ranking, and stemming.
FTS
SQLAlchemy + Postgres Cheatsheet 06 — Full-Text Search
Cheatsheet: generated tsvector, websearch_to_tsquery, ts_rank, headline snippets, trigram hybrid.