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...