Why PostgreSQL Why This Database Why Now at PGConfEU 2018

I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So one year in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest iPhone, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nociola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Why now? Well, I’ve been trying to find out, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL. (By Claire Giordano @clairegiordano)

Transcript

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

   View Slide

2. 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
   

   View Slide

3. PGConfEU 2018 | Lisbon, Portugal
   

   View Slide

4. 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
   

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

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

   View Slide

10. PGConfEU 2018 | Lisbon, Portugal
    10
    @clairegiordano
    

    View Slide

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

    View Slide

12. PGConfEU 2018 | Lisbon, Portugal
    12
    

    View Slide

13. PGConfEU 2018 | Lisbon, Portugal
    13
    Peter Eisentraut
    

    View Slide

14. 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.
    

    View Slide

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

    View Slide

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

    View Slide

17. 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
    

    View Slide

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

    View Slide

19. 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
    

    View Slide

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

    View Slide

21. PGConfEU 2018 | Lisbon, Portugal
    21
    @clairegiordano
    Dollars
    3
    

    View Slide

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

    View Slide

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

    View Slide

24. PGConfEU 2018 | Lisbon, Portugal
    24
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

30. 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
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

34. PGConfEU 2018 | Lisbon, Portugal
    

    View Slide

35. PGConfEU 2018 | Lisbon, Portugal
    

    View Slide

36. PGConfEU 2018 | Lisbon, Portugal
    10
    Extension APIs
    @clairegiordano
    

    View Slide

37. 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
    “
    

    View Slide

38. PGConfEU 2018 | Lisbon, Portugal
    

    View Slide

39. PGConfEU 2018 | Lisbon, Portugal
    

    View Slide

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

    View Slide

41. 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!
    

    View Slide

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

    View Slide