Spaghetti Carbonara, the PostgreSQL way

Slide 1

Slide 1 text

Spaghetti Carbonara, the PostgreSQL way Federico Campoli Transferwise 16 Nov 2017 https://github.com/the4thdoctor @4thdoctor scarf Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 1 / 21

Slide 2

Slide 2 text

The world’s most advanced open source chef PostgreSQL is an amazing RDBMS. Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 2 / 21

Slide 3

Slide 3 text

The world’s most advanced open source chef PostgreSQL is an amazing RDBMS. Which can help us to cook a delicious dish of Spaghetti Carbonara Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 2 / 21

Slide 4

Slide 4 text

The world’s most advanced open source chef Let’s ﬁnd out how! Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 3 / 21

Slide 5

Slide 5 text

Setup the schema First we need the containers. Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 4 / 21

Slide 6

Slide 6 text

Setup the schema Then let’s create a table for our ingredients. Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 5 / 21

Slide 7

Slide 7 text

Setup the schema A check constraint will help to tackle blasphemous ingredients in our carbonara Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 6 / 21

Slide 8

Slide 8 text

Add ingredients #1 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 7 / 21

Slide 9

Slide 9 text

Add ingredients #2 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 8 / 21

Slide 10

Slide 10 text

Add ingredients #3 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 9 / 21

Slide 11

Slide 11 text

Function carbonara #1 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 10 / 21

Slide 12

Slide 12 text

Function carbonara #2 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 11 / 21

Slide 13

Slide 13 text

Function carbonara #3 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 12 / 21

Slide 14

Slide 14 text

Function carbonara #4 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 13 / 21

Slide 15

Slide 15 text

Function carbonara #5 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 14 / 21

Slide 16

Slide 16 text

Function carbonara #6 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 15 / 21

Slide 17

Slide 17 text

Function carbonara #7 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 16 / 21

Slide 18

Slide 18 text

Function carbonara #8 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 17 / 21

Slide 19

Slide 19 text

Function carbonara #9 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 18 / 21

Slide 20

Slide 20 text

Boring legal stuﬀ Spaghetti carbonara, copyright Popo le Chien Pinkie Pie that’s all folks, Copyright by dan232323, used with permission The PostgreSQL Logo, Copyright PostgreSQL Global Development group Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 19 / 21

Slide 21

Slide 21 text

That’s all folks! Thank you for listening! GiST with the full working code available here https://goo.gl/66PCza Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 20 / 21

Slide 22

Slide 22 text

License This document is distributed under the terms of the Creative Commons Attribution, Not Commercial, Share Alike Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 21 / 21