Postgres Is All You Need for Full Text Search (Seriously)
Code: https://github.com/andfadeev/postgres...
Forgot to mention 2 useful extensions:
-- pg_trgm Fuzzy search using trigrams ILIKE, %, typo-tolerant search
CREATE EXTENSION IF NOT EXISTS pg_trgm;
-- unaccent Normalize accented characters Make “résumé” searchable as “resume”
CREATE EXTENSION IF NOT EXISTS unaccent;
Support the channel:
Buy Me a Coffee https://www.buymeacoffee.com/andrey.f...
Ko-fi https://ko-fi.com/andreyfadeev
Youtube / @andrey.fadeev
PayPal https://paypal.me/andfadeev
Follow me:
LinkedIn / andfadeev
X / andfadeev
Substack https://blog.andreyfadeev.com
Telegram https://t.me/andreyfadeevchannel
Github https://github.com/andfadeev
Instagram / andfadeev
I'm truly grateful for your support, and thank you for watching! 🙏