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. 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. 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. 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.
  4. 10.

    NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen

    people have so much affection for PostgreSQL 10 reasons @clairegiordano
  5. 24.

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

    http://bonkersworld.net/organizational-charts
  6. 28.

    NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen

    Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “
  7. 32.

    NORDIC PGDay 2019 | Copenhagen 32 Postgres is heating up

    Source: Hacker News Hiring Trends through Jan 2019 | hntrends.com Postgres MySQL MongoDB
  8. 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
  9. 36.

    NORDIC PGDay 2019 | Copenhagen 36 Source: Paul Ramsey PGConfEU

    2018 Keynote: Put some “where” in your WHERE clause; https://bit.ly/2NM3zqB
  10. 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 “
  11. 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 “
  12. 45.

    NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen

    45 Not everyone has to agree, up-front
  13. 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
  14. 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
  15. 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
  16. 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