Spaghetti Carbonara, the PostgreSQL way

F48fa173c6ddf4342e2c7b74ddec3bbe?s=47 Federico Campoli
November 16, 2017
200

Spaghetti Carbonara, the PostgreSQL way

How to cook a proper carbonara with PostgreSQL, the most advanced open source database

F48fa173c6ddf4342e2c7b74ddec3bbe?s=128

Federico Campoli

November 16, 2017
Tweet

Transcript

  1. 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
  2. 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
  3. 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
  4. The world’s most advanced open source chef Let’s find out

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

    (Transferwise) Spaghetti Carbonara, the PostgreSQL way 16 Nov 2017 4 / 21
  6. 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
  7. 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
  8. Add ingredients #1 Federico Campoli (Transferwise) Spaghetti Carbonara, the PostgreSQL

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

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

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

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

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

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

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

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

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

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

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

    way 16 Nov 2017 18 / 21
  20. Boring legal stuff 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
  21. 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
  22. 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