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

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.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

March 19, 2019
Tweet

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
  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
  3. NORDIC PGDay 2019 | Copenhagen

  4. NORDIC PGDay 2019 | Copenhagen 4 @clairegiordano

  5. NORDIC PGDay 2019 | Copenhagen 5 Peop le’s eyes ligh

    t up @clairegiordano
  6. NORDIC PGDay 2019 | Copenhagen 6

  7. NORDIC PGDay 2019 | Copenhagen 7 Peter Eisentraut

  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.
  9. NORDIC PGDay 2019 | Copenhagen Why PostgreSQL? Why This Database?

    Why Now? ? @clairegiordano
  10. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen

    people have so much affection for PostgreSQL 10 reasons @clairegiordano
  11. NORDIC PGDay 2019 | Copenhagen Open Source 1 @clairegiordano 0

    Octocat icon courtesy of GitHub
  12. NORDIC PGDay 2019 | Copenhagen

  13. NORDIC PGDay 2019 | Copenhagen

  14. NORDIC PGDay 2019 | Copenhagen

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

    ECOSYSTEM
  16. NORDIC PGDay 2019 | Copenhagen

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

    for the community.
  18. NORDIC PGDay 2019 | Copenhagen Community 9 @clairegiordano Photo courtesy

    of @pgconfeu, Oct 2018 Lisbon
  19. NORDIC PGDay 2019 | Copenhagen

  20. NORDIC PGDay 2019 | Copenhagen

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

  22. NORDIC PGDay 2019 | Copenhagen 22

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

  24. NORDIC PGDay 2019 | Copenhagen Source: Manu Cornet. Bonkers World.

    http://bonkersworld.net/organizational-charts
  25. NORDIC PGDay 2019 | Copenhagen 7 @clairegiordano Permissive license

  26. NORDIC PGDay 2019 | Copenhagen 26

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

  28. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen

    Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “
  29. NORDIC PGDay 2019 | Copenhagen 6 Trust Hardened Data Integrity

    Maintainability @clairegiordano
  30. NORDIC PGDay 2019 | Copenhagen @clairegiordano

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

  32. NORDIC PGDay 2019 | Copenhagen 32 Postgres is heating up

    Source: Hacker News Hiring Trends through Jan 2019 | hntrends.com Postgres MySQL MongoDB
  33. NORDIC PGDay 2019 | Copenhagen 4 Heroku helped to popularize

    Postgres @clairegiordano
  34. NORDIC PGDay 2019 | Copenhagen @clairegiordano 3 Timing of JSON

    & JSONB support
  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
  36. NORDIC PGDay 2019 | Copenhagen 36 Source: Paul Ramsey PGConfEU

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

  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 “
  39. NORDIC PGDay 2019 | Copenhagen And now……….. #1 reason

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

  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 “
  42. NORDIC PGDay 2019 | Copenhagen Michael Stonebraker Source: Wikipedia

  43. NORDIC PGDay 2019 | Copenhagen

  44. NORDIC PGDay 2019 | Copenhagen

  45. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen

    45 Not everyone has to agree, up-front
  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
  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
  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
  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
  50. NORDIC PGDay 2019 | Copenhagen Thank you! @citusdata @clairegiordano github.com/citusdata/citus

    @microsoft p.s. Socks & stickers