Why PostgreSQL Why This Database Why Now at PGConfEU 2018

024d6a0dd14fb31c804969a57a06dfbe?s=47 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)

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

October 26, 2018
Tweet

Transcript

  1. 1.

    PGConfEU 2018 | Lisbon, Portugal Why PostgreSQL Why This Database

    Why Now Claire Giordano / Citus Data @clairegiordano / @citusdata PGConfEU 2018 | Lisbon, Portugal
  2. 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
  3. 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
  4. 5.

    PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    courtesy of The Illustrated History of PostgreSQL by Peter Van Hardenberg
  5. 6.

    PGConfEU 2018 | Lisbon, Portugal Architecture Design Storage Indexing Co-location

    Roles Permissions Latency Disaster Recovery @clairegiordano
  6. 9.

    PGConfEU 2018 | Lisbon, Portugal @clairegiordano And now, after Paul

    Ramsey’s keynote— even my Starbucks will remind me of databases
  7. 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.
  8. 16.

    PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    so much affection for PostgreSQL reasons 1 @clairegiordano 0
  9. 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
  10. 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
  11. 22.

    PGConfEU 2018 | Lisbon, Portugal Source: Manu Cornet. Bonkers World.

    http://bonkersworld.net/organizational-charts
  12. 25.

    PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    courtesy of Peter van Hardenberg, The Illustrated History of Postgres
  13. 26.

    PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “
  14. 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
  15. 33.

    PGConfEU 2018 | Lisbon, Portugal 9 PostGIS is the “industry

    standard spatial database” @clairegiordano
  16. 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 “
  17. 40.

    PGConfEU 2018 | Lisbon, Portugal PostGIS Citus postgresql-HLL pg_partman pg_cron

    foreign data wrappers! postgresql-topn & so many many more
  18. 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!