Why PostgreSQL? Why This Database? Why Now? | Swiss PGDay 2019 | Claire Giordano

Why PostgreSQL? Why This Database? Why Now? | Swiss PGDay 2019 | Claire Giordano

Abstract from PostgreSQL talk delivered at Swiss PGDay in Rapperswil, Switzerland in June 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 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.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

June 28, 2019
Tweet

Transcript

  1. 1.

    Swiss PGDay 2019 | Rapperswil, Switzerland Why PostgreSQL Why This

    Database Why Now Claire Giordano, Citus Data / Microsoft @clairegiordano / @citusdata / @microsoft Now Part of Microsoft Swiss PGDay | Jun 2019 | Rapperswil
  2. 2.

    Swiss PGDay 2019 | Rapperswil, Switzerland 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 Athens > Nantes
  3. 8.

    Swiss PGDay 2019 | Rapperswil, Switzerland 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.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland people have so much affection for PostgreSQL 10 reasons @clairegiordano
  5. 12.

    Swiss PGDay 2019 | Rapperswil, Switzerland Why does it matter

    that Postgres is open source? How does the “open source-ness” of Postgres contribute to the growing popularity of Postgres? Because Postgres is free. As in freedom.
  6. 15.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland ECOSYSTEM Open source aspect of Postgres contributes to the thriving ecosystem of expertise, tooling, integrations.
  7. 16.

    Swiss PGDay 2019 | Rapperswil, Switzerland Don’t have to reinvent

    the wheel Onager-drawn cart in Sumeria c. 2500 BC. Public domain.
  8. 18.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland Open source means Postgres is not a black box.
  9. 19.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland It’s not open source, it’s open engineering.” possibly Simon Riggs, 2nd Quadrant “
  10. 28.

    Swiss PGDay 2019 | Rapperswil, Switzerland Source: Manu Cornet. Bonkers

    World. http://bonkersworld.net/organizational-charts
  11. 31.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “
  12. 33.

    Swiss PGDay 2019 | Rapperswil, Switzerland 6 Trust Hardened Data

    Integrity Maintainability @clairegiordano
  13. 35.
  14. 37.

    Swiss PGDay 2019 | Rapperswil, Switzerland 37 Postgres is heating

    up Source: Hacker News Hiring Trends through March 2019 | hntrends.com Postgres MySQL MongoDB
  15. 40.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland 40 PostGIS is the industry standard way to model spatial data in a database PostGIS graphic courtesy of www.postgis.net
  16. 41.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland 41 PostGIS matters because location is the universal foreign key” PostGIS graphic courtesy of www.postgis.net “ —Paul Ramsey
  17. 42.
  18. 44.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland Everything is related to everything else, but near things are more related than distant things.” —Waldo Tobler, American-Swiss geographer & cartographer “
  19. 47.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland 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 “
  20. 51.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland 51 Not everyone has to agree, up-front
  21. 52.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland 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
  22. 53.

    Swiss PGDay 2019 | Rapperswil, Switzerland Swiss PGDay 2019 |

    Rapperswil, Switzerland 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
  23. 54.

    Swiss PGDay 2019 | Rapperswil, Switzerland 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
  24. 55.

    Swiss PGDay 2019 | Rapperswil, Switzerland 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 Jeff Davis Samay Sharma PGConf.EU Conference committee Nordic PGDay conference committee Swiss PGDay conference committee Thank You!
  25. 56.

    Swiss PGDay 2019 | Rapperswil, Switzerland Thank @ clairegiordano @

    citusdata @ microsoft @ azureDBpostgres github.com/citusdata/citus you! p.s. Socks &stickers Now Part of Microsoft