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

Why PostgreSQL Why This Database Why Now at PGConfEU 2018

Citus Data
October 26, 2018

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)

Citus Data

October 26, 2018
Tweet

More Decks by Citus Data

Other Decks in Technology

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