Fix your Strings in PostgreSQL | Citus Con: An Event for Postgres 2022

138 Aufrufe

  • Danke für die Bewertung! Teile es mit Deinen Freunden!

    Danke für Deine Bewertung!

admin
Published
Video of a talk given by Francesco Tisiot at Citus Con: An Event for Postgres. Abstract: Strings are one of the most used types in databases; they can store pretty much any data and don't enforce any rules on the inserted input. Yet too much freedom sometimes leads to inconsistencies: is it Aivan or Aiven? Øyvind or Oyvind? Wine or Whine? These seemingly small differences can have bad side-effects, causing lookups to fail and incorrect aggregation results to be returned. Luckily all is not lost: PostgreSQL has some features that can help us make sense of the chaos.

In this talk you will learn what PostgreSQL has to offer: starting with pattern matching, passing by regular expressions, and ending with more advanced functionality exposed by the fuzzystrmatch and unaccent extensions. I'll demonstrate what tools can help you fixing string inconsistencies and how to avoid making the same mistakes again in the future. This session is recommended for anyone who deeply cares about their (string) data quality.

Francesco Tisiot comes from Verona, Italy and works as a Developer Advocate at Aiven. With his many years of experience as a data engineer, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 00:23 The problem with strings
⏩ 07:12 How can we fix these problems?
⏩ 09:32 Demo
⏩ 28:49 From chaos to order

✅ Learn more:
Watch more Citus Con talks: https://aka.ms/cituscon-playlist

Kategorien
Windows Reparieren
Kommentare deaktiviert.

Als nächstes

Яндекс.Метрика