Tweet
Tweet

Slide 1

Slide 1 text

Francesco Tisiot - Developer Advocate @ftisiot Fix Your Strings!

Slide 2

Slide 2 text

@ftisiot | @aiven_io Francesco Tisiot Tisio Tisiotto Tissiott Tizio Francisco Frank Fransiscos

Slide 3

Slide 3 text

@ftisiot | @aiven_io Strings Francesco 1200$ • books • stars • computers I come from Verona and I like football and good food 25-Jan-2021 ^@^@^A^@^A^@^P^P^@^@^A^@ ^@h^D^@^@^V^@^@^@(^@^@^@^P^@^@^@ ^@^@^@^A^@ ^@^@^@^@^@^@^D^@^@^R^K^@^@^R^K^@^@^@^@^@^@^@^@^@^ @ < < D4>~^?^? < D3>^@^@^@^@^@^@ ^@^@^@^@^@^@^@^@^@^@^@^@^@^@ ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^ @^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@

Slide 4

Slide 4 text

@ftisiot | @aiven_io I’m Francesco, a table for 2 Please Ok Fransisco

Slide 5

Slide 5 text

@ftisiot | @aiven_io CREATE TABLE MY_RESTAURANT_DATA CREATE TABLE MY_RESTAURANT_DATA ( ID SERIAL, CALLER_NAME VARCHAR, CALLER_SURNAME VARCHAR, ); CREATE TABLE MY_RESTAURANT_DATA ( ID SERIAL, CALLER_NAME VARCHAR, CALLER_SURNAME VARCHAR, EMAIL VARCHAR, PHONE_NUMBER VARCHAR, ); CREATE TABLE MY_RESTAURANT_DATA ( ID SERIAL, CALLER_NAME VARCHAR, CALLER_SURNAME VARCHAR, EMAIL VARCHAR, PHONE_NUMBER VARCHAR, BOOKING_DATE VARCHAR, ); CREATE TABLE MY_RESTAURANT_DATA ( ID SERIAL, CALLER_NAME VARCHAR, CALLER_SURNAME VARCHAR, EMAIL VARCHAR, PHONE_NUMBER VARCHAR, BOOKING_DATE VARCHAR, INTERESTS VARCHAR, PEOPLE VARCHAR );

Slide 6

Slide 6 text

@ftisiot | @aiven_io

Slide 7

Slide 7 text

@ftisiot | @aiven_io How can we fix?

Slide 8

Slide 8 text

@ftisiot | @aiven_io Unique Identifier e-mail ascii parsable different accounts symbols reassigned group accounts

Slide 9

Slide 9 text

@ftisiot | @aiven_io Entropy Never Decreases

Slide 10

Slide 10 text

@ftisiot | @aiven_io Avoid Future Chaos

Slide 11

Slide 11 text

@ftisiot | @aiven_io People

Slide 12

Slide 12 text

@ftisiot | @aiven_io Interests ARRAY

Slide 13

Slide 13 text

@ftisiot | @aiven_io booking_date DATE

Slide 14

Slide 14 text

@ftisiot | @aiven_io phone_number - email DOMAIN https:/ /dba.stackexchange.com/questions/68266/what-is-the-best-way-to-store-an-email-address-in-postgresql/165923#165923

Slide 15

Slide 15 text

@ftisiot | @aiven_io Name and Surname UNACCENT FUZZYSTRMATCH PGSIMILARITY

Slide 16

Slide 16 text

@ftisiot | @aiven_io From Chaos To Order

Slide 17

Slide 17 text

@ftisiot | @aiven_io Fix Your Strings - Array Functions - Date Functions - Pattern Matching - Domain - Email Domain - Unaccent - FuzzyStrMatch - Aiven https:/ /www.postgresql.org/docs/current/functions-array.html https:/ /www.postgresql.org/docs/current/functions-datetime.html https:/ /www.postgresql.org/docs/current/functions-matching.html https:/ /www.postgresql.org/docs/current/sql-createdomain.html https:/ /bit.ly/3ol6yfr https:/ /www.postgresql.org/docs/current/unaccent.html https:/ /www.postgresql.org/docs/current/fuzzystrmatch.html https:/ /aiven.io/