Anyone experienced with postgres full text search? I want to get something simpl... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		paradite on Dec 7, 2024 \| parent \| context \| favorite \| on: How to use Postgres for everything Anyone experienced with postgres full text search? I want to get something simple setup but couldn't get it to work. I want to match substrings like "/r/chatgpt" (sub reddits) in url links, but couldn't get it to match. Tried a few types of queries like phrase, plain, default, simple, english. All have some weird issues, either not matching special characters, or not matching substrings (partial match). Also I'm somewhat limited on the syntax side by what can be done with drizzle ORM.

jumping_frog on Dec 7, 2024 [–]

> I want to match substrings like "/r/chatgpt" (sub reddits) in url links, but couldn't get it to match.

This likely means tokenization striping out special characters. Try ngram search methods. They should work out of box.

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact