Slide 1

Slide 1 text

Swiss PGDay 2019 | Rapperswil, Switzerland Why PostgreSQL Why This Database Why Now Claire Giordano, Citus Data / Microsoft @clairegiordano / @citusdata / @microsoft Now Part of Microsoft Swiss PGDay | Jun 2019 | Rapperswil

Slide 2

Slide 2 text

Swiss PGDay 2019 | Rapperswil, Switzerland Preferred programming language Hi, I’m Claire—and I’m a Principal PM Manager at Microsoft, by way of the recent Citus Data acquisition, where I was VP of Marketing. @clairegiordano @citusdata @microsoft Citus Data > Microsoft Engineering > Product > Marketing Athens > Nantes

Slide 3

Slide 3 text

Swiss PGDay 2019 | Rapperswil, Switzerland

Slide 4

Slide 4 text

Swiss PGDay 2019 | Rapperswil, Switzerland 4 @clairegiordano

Slide 5

Slide 5 text

Swiss PGDay 2019 | Rapperswil, Switzerland 5 Peop le’s eyes ligh t up @clairegiordano

Slide 6

Slide 6 text

Swiss PGDay 2019 | Rapperswil, Switzerland 6

Slide 7

Slide 7 text

Swiss PGDay 2019 | Rapperswil, Switzerland 7 Peter Eisentraut

Slide 8

Slide 8 text

Swiss PGDay 2019 | Rapperswil, Switzerland 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

Swiss PGDay 2019 | Rapperswil, Switzerland Why PostgreSQL? Why This Database? Why Now? ? @clairegiordano

Slide 10

Slide 10 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland people have so much affection for PostgreSQL 10 reasons @clairegiordano

Slide 11

Slide 11 text

Swiss PGDay 2019 | Rapperswil, Switzerland Open Source 1 @clairegiordano 0 Octocat icon courtesy of GitHub

Slide 12

Slide 12 text

Swiss PGDay 2019 | Rapperswil, Switzerland Why does it matter that Postgres is open source? How does the “open source-ness” of Postgres contribute to the growing popularity of Postgres? Because Postgres is free. As in freedom.

Slide 13

Slide 13 text

Swiss PGDay 2019 | Rapperswil, Switzerland Easy for developers to kick the tires.

Slide 14

Slide 14 text

Swiss PGDay 2019 | Rapperswil, Switzerland Able to avoid vendor lock-in.

Slide 15

Slide 15 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland ECOSYSTEM Open source aspect of Postgres contributes to the thriving ecosystem of expertise, tooling, integrations.

Slide 16

Slide 16 text

Swiss PGDay 2019 | Rapperswil, Switzerland Don’t have to reinvent the wheel Onager-drawn cart in Sumeria c. 2500 BC. Public domain.

Slide 17

Slide 17 text

Swiss PGDay 2019 | Rapperswil, Switzerland Transparency of open source.

Slide 18

Slide 18 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland Open source means Postgres is not a black box.

Slide 19

Slide 19 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland It’s not open source, it’s open engineering.” possibly Simon Riggs, 2nd Quadrant “

Slide 20

Slide 20 text

Swiss PGDay 2019 | Rapperswil, Switzerland

Slide 21

Slide 21 text

Swiss PGDay 2019 | Rapperswil, Switzerland Come for the code. Stay for the community.

Slide 22

Slide 22 text

Swiss PGDay 2019 | Rapperswil, Switzerland Community 9 @clairegiordano Photo courtesy of @pgconfeu, Oct 2018 Lisbon

Slide 23

Slide 23 text

Swiss PGDay 2019 | Rapperswil, Switzerland

Slide 24

Slide 24 text

Swiss PGDay 2019 | Rapperswil, Switzerland

Slide 25

Slide 25 text

Swiss PGDay 2019 | Rapperswil, Switzerland 25

Slide 26

Slide 26 text

Swiss PGDay 2019 | Rapperswil, Switzerland Source: https://www.pgcon.org/2016/schedule/events/890.en.html

Slide 27

Slide 27 text

Swiss PGDay 2019 | Rapperswil, Switzerland 27 @clairegiordano Not Oracle 8

Slide 28

Slide 28 text

Swiss PGDay 2019 | Rapperswil, Switzerland Source: Manu Cornet. Bonkers World. http://bonkersworld.net/organizational-charts

Slide 29

Slide 29 text

Swiss PGDay 2019 | Rapperswil, Switzerland 7 @clairegiordano Permissive license

Slide 30

Slide 30 text

Swiss PGDay 2019 | Rapperswil, Switzerland 30

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

Swiss PGDay 2019 | Rapperswil, Switzerland https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

Slide 33

Slide 33 text

Swiss PGDay 2019 | Rapperswil, Switzerland 6 Trust Hardened Data Integrity Maintainability @clairegiordano

Slide 34

Slide 34 text

Swiss PGDay 2019 | Rapperswil, Switzerland @clairegiordano

Slide 35

Slide 35 text

Swiss PGDay 2019 | Rapperswil, Switzerland 5 Heroku helped to popularize Postgres @clairegiordano

Slide 36

Slide 36 text

Swiss PGDay 2019 | Rapperswil, Switzerland 4NoSQL did not eat the world @clairegiordano

Slide 37

Slide 37 text

Swiss PGDay 2019 | Rapperswil, Switzerland 37 Postgres is heating up Source: Hacker News Hiring Trends through March 2019 | hntrends.com Postgres MySQL MongoDB

Slide 38

Slide 38 text

Swiss PGDay 2019 | Rapperswil, Switzerland @clairegiordano 3 Timing of JSON & JSONB support

Slide 39

Slide 39 text

Swiss PGDay 2019 | Rapperswil, Switzerland 2 @clairegiordano CREATE EXTENSION postgis; PostGIS Photo by Claire Giordano

Slide 40

Slide 40 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland 40 PostGIS is the industry standard way to model spatial data in a database PostGIS graphic courtesy of www.postgis.net

Slide 41

Slide 41 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland 41 PostGIS matters because location is the universal foreign key” PostGIS graphic courtesy of www.postgis.net “ —Paul Ramsey

Slide 42

Slide 42 text

Swiss PGDay 2019 | Rapperswil, Switzerland Visualizing patterns & relations by geographic properties is a powerful thing.

Slide 43

Slide 43 text

Swiss PGDay 2019 | Rapperswil, Switzerland 43

Slide 44

Slide 44 text

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

Slide 45

Slide 45 text

Swiss PGDay 2019 | Rapperswil, Switzerland And now……….. #1 reason

Slide 46

Slide 46 text

Swiss PGDay 2019 | Rapperswil, Switzerland 1 Extension APIs @clairegiordano

Slide 47

Slide 47 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland 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 48

Slide 48 text

Swiss PGDay 2019 | Rapperswil, Switzerland Michael Stonebraker Source: Wikipedia

Slide 49

Slide 49 text

Swiss PGDay 2019 | Rapperswil, Switzerland

Slide 50

Slide 50 text

Swiss PGDay 2019 | Rapperswil, Switzerland

Slide 51

Slide 51 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland 51 Not everyone has to agree, up-front

Slide 52

Slide 52 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland 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 53

Slide 53 text

Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 | Rapperswil, Switzerland 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 54

Slide 54 text

Swiss PGDay 2019 | Rapperswil, Switzerland It’s deeply satisfying to work on a technology (PostgreSQL!) that not only delights developers, but makes their lives light years better.” “ —Claire Giordano, Nordic PGDay 2019 @clairegiordano

Slide 55

Slide 55 text

Swiss PGDay 2019 | Rapperswil, Switzerland 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 Devrim Gündüz Jeff Davis Samay Sharma PGConf.EU Conference committee Nordic PGDay conference committee Swiss PGDay conference committee Thank You!

Slide 56

Slide 56 text

Swiss PGDay 2019 | Rapperswil, Switzerland Thank @ clairegiordano @ citusdata @ microsoft @ azureDBpostgres github.com/citusdata/citus you! p.s. Socks &stickers Now Part of Microsoft