$30 off During Our Annual Pro Sale. View Details »

Why Postgres Why This Database Why Now Nordic PGDay 2019

Why Postgres Why This Database Why Now Nordic PGDay 2019

Abstract from talk given at Nordic PGDay in Copenhagen in March of 2019:

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.

Claire Giordano

March 19, 2019
Tweet

More Decks by Claire Giordano

Other Decks in Technology

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