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

Why-PostgreSQL-Why-This-Database-Why-Now-SFBayAreaPostgres-23July2019-Claire-Giordano-Microsoft.pdf

 Why-PostgreSQL-Why-This-Database-Why-Now-SFBayAreaPostgres-23July2019-Claire-Giordano-Microsoft.pdf

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 almost 2 years 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 gadget, or Ronaldo’s phenomenal free-kick goal in the World Cup, or mint chip gelato from La Strega Nocciola—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”? Well, I’ve been trying to understand, 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.

Citus Data

July 23, 2019
Tweet

More Decks by Citus Data

Other Decks in Technology

Transcript

  1. SF Bay Area PostgreSQL Meetup | San Francisco
    Why PostgreSQL
    Why This Database
    Why Now
    Claire Giordano, Citus Data / Microsoft
    @clairegiordano / @citusdata / @azuredbpostgres
    Now Part of Microsoft
    SF Bay Area PostgreSQL Meetup 7.23.19

    View Slide

  2. SF Bay Area PostgreSQL Meetup | San Francisco
    Hi, I’m Claire—and I’m a
    Principal PM Manager
    at Microsoft, by way of the
    recent Citus Data
    acquisition, where I was
    VP of Marketing.

    View Slide

  3. SF Bay Area PostgreSQL Meetup | San Francisco
    Hi, I’m Claire—and I’m a
    Principal PM Manager
    at Microsoft, by way of the
    recent Citus Data
    acquisition, where I was
    VP of Marketing.
    Engineering > Product > Marketing

    View Slide

  4. SF Bay Area PostgreSQL Meetup | San Francisco
    Preferred programming language
    Hi, I’m Claire—and I’m a
    Principal PM Manager
    at Microsoft, by way of the
    recent Citus Data
    acquisition, where I was
    VP of Marketing.
    Engineering > Product > Marketing

    View Slide

  5. SF Bay Area PostgreSQL Meetup | San Francisco
    Preferred programming language
    Hi, I’m Claire—and I’m a
    Principal PM Manager
    at Microsoft, by way of the
    recent Citus Data
    acquisition, where I was
    VP of Marketing.
    @clairegiordano @citusdata @microsoft
    Citus Data > Microsoft
    Engineering > Product > Marketing

    View Slide

  6. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  7. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    7
    @clairegiordano

    View Slide

  8. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    8
    Peop
    le’s
    eyes
    ligh
    t up
    @clairegiordano

    View Slide

  9. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    9

    View Slide

  10. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    10
    Peter Eisentraut

    View Slide

  11. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    11
    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

  12. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Why PostgreSQL?
    Why This Database?
    Why Now?
    ?
    @clairegiordano

    View Slide

  13. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    people have so much affection for PostgreSQL
    10 reasons
    @clairegiordano

    View Slide

  14. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Open Source
    1
    @clairegiordano
    0
    Octocat icon courtesy of GitHub

    View Slide

  15. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  16. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  17. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  18. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    ECOSYSTEM

    View Slide

  19. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  20. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  21. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    It’s not open source,
    it’s open engineering.”
    possibly Simon Riggs,
    2nd Quadrant

    View Slide

  22. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  23. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Come for the code. Stay for the community.

    View Slide

  24. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Community
    9
    @clairegiordano Photo courtesy of @pgconfeu, Oct 2018 Lisbon

    View Slide

  25. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  26. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  27. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    27

    View Slide

  28. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Source: https://www.pgcon.org/2016/schedule/events/890.en.html

    View Slide

  29. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    29
    @clairegiordano
    Not Oracle
    8

    View Slide

  30. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Source: Manu Cornet. Bonkers World. http://bonkersworld.net/organizational-charts

    View Slide

  31. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    7
    @clairegiordano
    Permissive
    license

    View Slide

  32. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    32

    View Slide

  33. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Forks make the community
    strong.”
    —Peter van Hardenberg,
    Illustrated History of Postgres

    View Slide

  34. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

    View Slide

  35. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    6
    Trust
    Hardened
    Data Integrity
    Maintainability
    @clairegiordano

    View Slide

  36. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    @clairegiordano

    View Slide

  37. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    5
    Heroku helped to
    popularize
    Postgres
    @clairegiordano

    View Slide

  38. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    4NoSQL
    did
    not eat
    the
    world
    @clairegiordano

    View Slide

  39. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    39
    Postgres is heating up
    Source: Hacker News Hiring Trends through March 2019 | hntrends.com
    Postgres
    MySQL
    MongoDB

    View Slide

  40. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    @clairegiordano
    3
    Timing of JSON &
    JSONB
    support

    View Slide

  41. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    2
    @clairegiordano
    CREATE EXTENSION postgis;
    PostGIS
    Photo by Claire Giordano

    View Slide

  42. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    42
    PostGIS is the
    industry
    standard way
    to model spatial
    data in a
    database
    PostGIS graphic courtesy of www.postgis.net

    View Slide

  43. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    43
    PostGIS
    matters
    because
    location is the
    universal
    foreign key”
    PostGIS graphic courtesy of www.postgis.net

    —Paul Ramsey

    View Slide

  44. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  45. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Visualizing patterns & relations by
    geographic properties is a powerful thing.

    View Slide

  46. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    46

    View Slide

  47. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Everything is related to
    everything else, but near things
    are more related than distant
    things.”
    —Waldo Tobler, American-Swiss geographer
    & cartographer

    View Slide

  48. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    And now……….. #1 reason

    View Slide

  49. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    1
    Extension APIs
    @clairegiordano

    View Slide

  50. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    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

  51. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Michael
    Stonebraker
    Source: Wikipedia

    View Slide

  52. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  53. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco

    View Slide

  54. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    54
    Not everyone has to agree, up-front

    View Slide

  55. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    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

  56. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    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

  57. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    It’s deeply satisfying to
    work on a technology
    (PostgreSQL!) that not
    only delights developers,
    but makes their lives light
    years better.”

    —Claire Giordano,
    Nordic PGDay 2019
    @clairegiordano

    View Slide

  58. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    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
    Devrim Gündüz
    Thank You!

    View Slide

  59. SF Bay Area PostgreSQL Meetup | July 2019 | San Francisco
    Thank
    @ clairegiordano
    @ citusdata
    @ microsoft
    @ azureDBpostgres
    github.com/citusdata/citus
    you!
    p.s. Socks
    &stickers
    Now Part of Microsoft

    View Slide