Slide 1

Slide 1 text

NORDIC PGDay 2019 | Copenhagen Why PostgreSQL Why This Database Why Now Claire Giordano / Citus Data / Microsoft @clairegiordano / @citusdata / @microsoft 19 Mar 2019 | Copenhagen

Slide 2

Slide 2 text

NORDIC PGDay 2019 | Copenhagen 2 Engineering > Product > Marketing Lycee d’etat Jules Verne Papagos, Athens, Greece Citus Data > Microsoft @clairegiordano / @citusdata Preferred programming language

Slide 3

Slide 3 text

NORDIC PGDay 2019 | Copenhagen

Slide 4

Slide 4 text

NORDIC PGDay 2019 | Copenhagen 4 @clairegiordano

Slide 5

Slide 5 text

NORDIC PGDay 2019 | Copenhagen 5 Peop le’s eyes ligh t up @clairegiordano

Slide 6

Slide 6 text

NORDIC PGDay 2019 | Copenhagen 6

Slide 7

Slide 7 text

NORDIC PGDay 2019 | Copenhagen 7 Peter Eisentraut

Slide 8

Slide 8 text

NORDIC PGDay 2019 | Copenhagen 8 Dimitri Fontaine at PGConfEU 2018. Photo by Claire Giordano. Peter Eisentraut at PGConfEU 2018. Photo by Claire Giordano. Lætitia Avrot at PGConfEU 2018. Photo by Claire Giordano. Stephen Frost at PGConfEU 2018. Photo by Claire Giordano.

Slide 9

Slide 9 text

NORDIC PGDay 2019 | Copenhagen Why PostgreSQL? Why This Database? Why Now? ? @clairegiordano

Slide 10

Slide 10 text

NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen people have so much affection for PostgreSQL 10 reasons @clairegiordano

Slide 11

Slide 11 text

NORDIC PGDay 2019 | Copenhagen Open Source 1 @clairegiordano 0 Octocat icon courtesy of GitHub

Slide 12

Slide 12 text

NORDIC PGDay 2019 | Copenhagen

Slide 13

Slide 13 text

NORDIC PGDay 2019 | Copenhagen

Slide 14

Slide 14 text

NORDIC PGDay 2019 | Copenhagen

Slide 15

Slide 15 text

NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen ECOSYSTEM

Slide 16

Slide 16 text

NORDIC PGDay 2019 | Copenhagen

Slide 17

Slide 17 text

NORDIC PGDay 2019 | Copenhagen Come for the code. Stay for the community.

Slide 18

Slide 18 text

NORDIC PGDay 2019 | Copenhagen Community 9 @clairegiordano Photo courtesy of @pgconfeu, Oct 2018 Lisbon

Slide 19

Slide 19 text

NORDIC PGDay 2019 | Copenhagen

Slide 20

Slide 20 text

NORDIC PGDay 2019 | Copenhagen

Slide 21

Slide 21 text

NORDIC PGDay 2019 | Copenhagen Source: https://www.pgcon.org/2016/schedule/events/890.en.html

Slide 22

Slide 22 text

NORDIC PGDay 2019 | Copenhagen 22

Slide 23

Slide 23 text

NORDIC PGDay 2019 | Copenhagen 23 @clairegiordano Not Oracle 8

Slide 24

Slide 24 text

NORDIC PGDay 2019 | Copenhagen Source: Manu Cornet. Bonkers World. http://bonkersworld.net/organizational-charts

Slide 25

Slide 25 text

NORDIC PGDay 2019 | Copenhagen 7 @clairegiordano Permissive license

Slide 26

Slide 26 text

NORDIC PGDay 2019 | Copenhagen 26

Slide 27

Slide 27 text

NORDIC PGDay 2019 | Copenhagen https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

Slide 28

Slide 28 text

NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “

Slide 29

Slide 29 text

NORDIC PGDay 2019 | Copenhagen 6 Trust Hardened Data Integrity Maintainability @clairegiordano

Slide 30

Slide 30 text

NORDIC PGDay 2019 | Copenhagen @clairegiordano

Slide 31

Slide 31 text

NORDIC PGDay 2019 | Copenhagen 5Trend away from NoSQL @clairegiordano

Slide 32

Slide 32 text

NORDIC PGDay 2019 | Copenhagen 32 Postgres is heating up Source: Hacker News Hiring Trends through Jan 2019 | hntrends.com Postgres MySQL MongoDB

Slide 33

Slide 33 text

NORDIC PGDay 2019 | Copenhagen 4 Heroku helped to popularize Postgres @clairegiordano

Slide 34

Slide 34 text

NORDIC PGDay 2019 | Copenhagen @clairegiordano 3 Timing of JSON & JSONB support

Slide 35

Slide 35 text

NORDIC PGDay 2019 | Copenhagen 2 @clairegiordano CREATE EXTENSION postgis; PostGIS is industry standard way to model spatial data in a database Photo by Claire Giordano

Slide 36

Slide 36 text

NORDIC PGDay 2019 | Copenhagen 36 Source: Paul Ramsey PGConfEU 2018 Keynote: Put some “where” in your WHERE clause; https://bit.ly/2NM3zqB

Slide 37

Slide 37 text

NORDIC PGDay 2019 | Copenhagen 37

Slide 38

Slide 38 text

NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen Everything is related to everything else, but near things are more related than distant things.” —Waldo Tobler, American-Swiss geographer & cartographer “

Slide 39

Slide 39 text

NORDIC PGDay 2019 | Copenhagen And now……….. #1 reason

Slide 40

Slide 40 text

NORDIC PGDay 2019 | Copenhagen 1 Extension APIs @clairegiordano

Slide 41

Slide 41 text

NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen We are still dining out on the radical design decision by Michael Stonebraker in the Design of Postgres—to have run-time extensions.” —Paul Ramsey, Lisbon, PGConfEU 2018 “

Slide 42

Slide 42 text

NORDIC PGDay 2019 | Copenhagen Michael Stonebraker Source: Wikipedia

Slide 43

Slide 43 text

NORDIC PGDay 2019 | Copenhagen

Slide 44

Slide 44 text

NORDIC PGDay 2019 | Copenhagen

Slide 45

Slide 45 text

NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen 45 Not everyone has to agree, up-front

Slide 46

Slide 46 text

NORDIC PGDay 2019 | Copenhagen PostGIS Citus postgresql-HLL pg_partman pg_cron postgresql-topn postgresql-unit pguri postgis.net/ citusdata/citus citusdata/postgresql-hll pgpartman/pg_partman petere/pguri citusdata/pg_cron ChristophBerg/postgresql-unit citusdata/postgresql-topn

Slide 47

Slide 47 text

NORDIC PGDay 2019 | Copenhagen PostGIS Citus postgresql-HLL pg_partman pg_cron postgresql-topn postgresql-unit pguri postgis.net/ citusdata/citus citusdata/postgresql-hll pgpartman/pg_partman petere/pguri citusdata/pg_cron ChristophBerg/postgresql-unit citusdata/postgresql-topn AND SO MANY MORE POSTGRES EXTENSIONS AND MORE THAT WE HAVEN’T YET IMAGINED

Slide 48

Slide 48 text

NORDIC PGDay 2019 | Copenhagen Thank You! Matt Asay Lætitia Avrot Dave Cramer Herb Cunitz Nils Dijk Peter Eisentraut Vik Fearing Dimitri Fontaine Stephen Frost Önder Kalaci Amit Kapila Günce Kaya Craig Kerstiens Paul Ramsey Marco Slot Sai Srirampur My Nguyen Peter van Hardenberg Tom Lane Jonathan Katz PGConfEU audience Isaac Alves Danese Cooper

Slide 49

Slide 49 text

NORDIC PGDay 2019 | Copenhagen Working on Postgres and Citus, I’ve found bliss—it’s deeply satisfying to work on a technology that not only delights developers, but makes their lives light years better.” “ —Claire Giordano, Nordic PGDay 2019 @clairegiordano

Slide 50

Slide 50 text

NORDIC PGDay 2019 | Copenhagen Thank you! @citusdata @clairegiordano github.com/citusdata/citus @microsoft p.s. Socks & stickers