Slide 1

Slide 1 text

PGConfEU 2018 | Lisbon, Portugal Why PostgreSQL Why This Database Why Now Claire Giordano / Citus Data @clairegiordano / @citusdata PGConfEU 2018 | Lisbon, Portugal

Slide 2

Slide 2 text

PGConfEU 2018 | Lisbon, Portugal 2 Lycee d’etat Jules Verne Papagos, Athens, Greece Curious (or is it Empathy?) Developer > Engineering Manager > Product Manager > Marketing Developer tools > SunOS > File systems > Scale out storage Citus Data @clairegiordano

Slide 3

Slide 3 text

PGConfEU 2018 | Lisbon, Portugal

Slide 4

Slide 4 text

PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal How do you pronounce PostgreSQL? 1. post-gres 2. post-gres-cue-ell 3. post-gres-S-cue-ell 4. post-grey-something

Slide 5

Slide 5 text

PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal courtesy of The Illustrated History of PostgreSQL by Peter Van Hardenberg

Slide 6

Slide 6 text

PGConfEU 2018 | Lisbon, Portugal Architecture Design Storage Indexing Co-location Roles Permissions Latency Disaster Recovery @clairegiordano

Slide 7

Slide 7 text

PGConfEU 2018 | Lisbon, Portugal Do you see what I see? @clairegiordano

Slide 8

Slide 8 text

PGConfEU 2018 | Lisbon, Portugal The back of the Kleenex is even worse! @clairegiordano

Slide 9

Slide 9 text

PGConfEU 2018 | Lisbon, Portugal @clairegiordano And now, after Paul Ramsey’s keynote— even my Starbucks will remind me of databases

Slide 10

Slide 10 text

PGConfEU 2018 | Lisbon, Portugal 10 @clairegiordano

Slide 11

Slide 11 text

PGConfEU 2018 | Lisbon, Portugal 11 Peop le’s eyes ligh t up @clairegiordano

Slide 12

Slide 12 text

PGConfEU 2018 | Lisbon, Portugal 12

Slide 13

Slide 13 text

PGConfEU 2018 | Lisbon, Portugal 13 Peter Eisentraut

Slide 14

Slide 14 text

PGConfEU 2018 | Lisbon, Portugal 14 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 15

Slide 15 text

PGConfEU 2018 | Lisbon, Portugal Why PostgreSQL? Why This Database? Why Now? ? @clairegiordano

Slide 16

Slide 16 text

PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal so much affection for PostgreSQL reasons 1 @clairegiordano 0

Slide 17

Slide 17 text

PGConfEU 2018 | Lisbon, Portugal 17 No, finding a real-world Starbucks location is NOT one of the reasons. Or is it? Source: Paul Ramsey PGConfEU Oct 2018 keynote in Lisbon, Portugal: Put some “where” in your WHERE clause

Slide 18

Slide 18 text

PGConfEU 2018 | Lisbon, Portugal Open Source 1 @clairegiordano Octocat icon courtesy of GitHub

Slide 19

Slide 19 text

PGConfEU 2018 | Lisbon, Portugal free kick the tires avoid vendor lock-in larger ecosystem shoulders of giants DOES OPEN SOURCE MATTER? fuel for collaboration transparency::sunlight

Slide 20

Slide 20 text

PGConfEU 2018 | Lisbon, Portugal Community 2 @clairegiordano Photo courtesy of @pgconfeu, Oct 2018 Lisbon

Slide 21

Slide 21 text

PGConfEU 2018 | Lisbon, Portugal 21 @clairegiordano Dollars 3

Slide 22

Slide 22 text

PGConfEU 2018 | Lisbon, Portugal Source: Manu Cornet. Bonkers World. http://bonkersworld.net/organizational-charts

Slide 23

Slide 23 text

PGConfEU 2018 | Lisbon, Portugal Permissive open source license 4 @clairegiordano

Slide 24

Slide 24 text

PGConfEU 2018 | Lisbon, Portugal 24

Slide 25

Slide 25 text

PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal courtesy of Peter van Hardenberg, The Illustrated History of Postgres

Slide 26

Slide 26 text

PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “

Slide 27

Slide 27 text

PGConfEU 2018 | Lisbon, Portugal https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases PGConfEU 2018 | Lisbon, Portugal https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

Slide 28

Slide 28 text

PGConfEU 2018 | Lisbon, Portugal 5 Data Integrity Maintainability Trust Hardened @clairegiordano

Slide 29

Slide 29 text

PGConfEU 2018 | Lisbon, Portugal 6 Trend away from NoSQL @clairegiordano

Slide 30

Slide 30 text

PGConfEU 2018 | Lisbon, Portugal 30 Postgres is on fire PostgreSQL MySQL MongoDB SQL Server + Oracle Source: % database job postings that mention each specific technology, across 20K+ job posts on Hacker News, https://news.ycombinator.com

Slide 31

Slide 31 text

PGConfEU 2018 | Lisbon, Portugal 7 Heroku helped to popularize Postgres @clairegiordano

Slide 32

Slide 32 text

PGConfEU 2018 | Lisbon, Portugal @clairegiordano 8 Timing of JSON & JSONB support

Slide 33

Slide 33 text

PGConfEU 2018 | Lisbon, Portugal 9 PostGIS is the “industry standard spatial database” @clairegiordano

Slide 34

Slide 34 text

PGConfEU 2018 | Lisbon, Portugal

Slide 35

Slide 35 text

PGConfEU 2018 | Lisbon, Portugal

Slide 36

Slide 36 text

PGConfEU 2018 | Lisbon, Portugal 10 Extension APIs @clairegiordano

Slide 37

Slide 37 text

PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal 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, PGConfEU 2018 “

Slide 38

Slide 38 text

PGConfEU 2018 | Lisbon, Portugal

Slide 39

Slide 39 text

PGConfEU 2018 | Lisbon, Portugal

Slide 40

Slide 40 text

PGConfEU 2018 | Lisbon, Portugal PostGIS Citus postgresql-HLL pg_partman pg_cron foreign data wrappers! postgresql-topn & so many many more

Slide 41

Slide 41 text

PGConfEU 2018 | Lisbon, Portugal 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 Peter van Hardenberg 41 Thank You!

Slide 42

Slide 42 text

PGConfEU 2018 | Lisbon, Portugal Because Postgres @citusdata @clairegiordano github.com/citusdata/citus please be sure to add a star to our github repo!