Spaghetti Carbonara, the PostgreSQL way

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

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