5mins of Postgres E23: Fuzzy text search & case-insensitive ICU collations in Postgres
Today, we're going to talk about fuzzy text search in Postgres with LIKE/ILIKE, trigrams, levenshtein distances, as well as case-insensitive pattern matching.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
PostgreSQL Fuzzy Text Search: Not so fuzzy to fuzziest - by Brendan Scullion: https://blog.brendanscullion.com/post...
Brendan Scullion on Twitter: / brsc2909
Full Text Search in Milliseconds with Rails and PostgreSQL: https://pganalyze.com/blog/full-text-...
Understanding Postgres GIN Indexes: The Good and the Bad: https://pganalyze.com/blog/gin-index
Similarity in Postgres and Rails using Trigrams: https://pganalyze.com/blog/similarity...
5mins of Postgres E6: Optimizing Postgres Text Search with Trigrams and GiST indexes: https://pganalyze.com/blog/5mins-post...
pganalyze eBook: Efficient Search in Rails with Postgres: https://pganalyze.com/ebooks/efficien...
Efficient Postgres Full Text Search in Django: https://pganalyze.com/blog/full-text-...
Searching with Levenshtein distances in Postgres: https://www.postgresql.org/docs/curre...
soundex function in Postgres: https://www.postgresql.org/docs/curre...
Case-insensitive pattern matching in PostgreSQL - by Laurenz Albe: https://www.cybertec-postgresql.com/e...
citext function in Postgres: https://www.postgresql.org/docs/curre...)\
Webinar recording: How to reason about indexing your Postgres database: • Webinar recording: How to reason about ind...