Explore techniques for improving string data quality in PostgreSQL databases in this 30-minute conference talk from Citus Con: An Event for Postgres 2022. Learn about pattern matching, regular expressions, and advanced functionality offered by the fuzzystrmatch and unaccent extensions. Discover tools to fix string inconsistencies and prevent future errors, with practical demonstrations and expert advice from Francesco Tisiot, a Developer Advocate at Aiven. Gain insights into handling common string-related challenges, such as name variations and character encoding issues, to enhance data accuracy and query performance.
Overview
Syllabus
Introduction.
The problem with strings.
How can we fix these problems?.
Demo.
From chaos to order.
Taught by
Microsoft Developer
