Why PostgreSQL Why This Database Why Now | Nordic PGDay 2019 | Claire Giordano

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.

Transcript

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

   View Slide

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

   View Slide

3. NORDIC PGDay 2019 | Copenhagen
   

   View Slide

4. NORDIC PGDay 2019 | Copenhagen
   4
   @clairegiordano
   

   View Slide

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

   View Slide

6. NORDIC PGDay 2019 | Copenhagen
   6
   

   View Slide

7. NORDIC PGDay 2019 | Copenhagen
   7
   Peter Eisentraut
   

   View Slide

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

   View Slide

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

   View Slide

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

    View Slide

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

    View Slide

12. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

13. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

14. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

15. NORDIC PGDay 2019 | Copenhagen
    NORDIC PGDay 2019 | Copenhagen
    ECOSYSTEM
    

    View Slide

16. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

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

    View Slide

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

    View Slide

19. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

20. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

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

    View Slide

22. NORDIC PGDay 2019 | Copenhagen
    22
    

    View Slide

23. NORDIC PGDay 2019 | Copenhagen
    23
    @clairegiordano
    Not Oracle
    8
    

    View Slide

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

    View Slide

25. NORDIC PGDay 2019 | Copenhagen
    7
    @clairegiordano
    Permissive
    license
    

    View Slide

26. NORDIC PGDay 2019 | Copenhagen
    26
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

30. NORDIC PGDay 2019 | Copenhagen
    @clairegiordano
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

37. NORDIC PGDay 2019 | Copenhagen
    37
    

    View Slide

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

    View Slide

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

    View Slide

40. NORDIC PGDay 2019 | Copenhagen
    1
    Extension APIs
    @clairegiordano
    

    View Slide

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

    View Slide

42. NORDIC PGDay 2019 | Copenhagen
    Michael
    Stonebraker
    Source: Wikipedia
    

    View Slide

43. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

44. NORDIC PGDay 2019 | Copenhagen
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide