Creating a search catalog in PostgreSQL using full text indexing

Creating a full text index in PostgreSQL is an extremely powerful way to add a full-featured, comprehensive search function to your application. Full text indexing is probably the most under-appreciated feature of PostgreSQL, but it’s there and you can take advantage of it!

The code and data is here: https://bigmachine.io/2022/06/12/creating-a-full-text-search-engine-in-postgresql-2022/
Postgres resources: https://bigmachine.io/products/a-curious-moon/