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. PGConfEU 2018 | Lisbon, Portugal Why PostgreSQL Why This Database

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

  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
  5. PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    courtesy of The Illustrated History of PostgreSQL by Peter Van Hardenberg
  6. PGConfEU 2018 | Lisbon, Portugal Architecture Design Storage Indexing Co-location

    Roles Permissions Latency Disaster Recovery @clairegiordano
  7. PGConfEU 2018 | Lisbon, Portugal Do you see what I

    see? @clairegiordano
  8. PGConfEU 2018 | Lisbon, Portugal The back of the Kleenex

    is even worse! @clairegiordano
  9. PGConfEU 2018 | Lisbon, Portugal @clairegiordano And now, after Paul

    Ramsey’s keynote— even my Starbucks will remind me of databases
  10. PGConfEU 2018 | Lisbon, Portugal 10 @clairegiordano

  11. PGConfEU 2018 | Lisbon, Portugal 11 Peop le’s eyes ligh

    t up @clairegiordano
  12. PGConfEU 2018 | Lisbon, Portugal 12

  13. PGConfEU 2018 | Lisbon, Portugal 13 Peter Eisentraut

  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.
  15. PGConfEU 2018 | Lisbon, Portugal Why PostgreSQL? Why This Database?

    Why Now? ? @clairegiordano
  16. PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    so much affection for PostgreSQL reasons 1 @clairegiordano 0
  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
  18. PGConfEU 2018 | Lisbon, Portugal Open Source 1 @clairegiordano Octocat

    icon courtesy of GitHub
  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
  20. PGConfEU 2018 | Lisbon, Portugal Community 2 @clairegiordano Photo courtesy

    of @pgconfeu, Oct 2018 Lisbon
  21. PGConfEU 2018 | Lisbon, Portugal 21 @clairegiordano Dollars 3

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

    http://bonkersworld.net/organizational-charts
  23. PGConfEU 2018 | Lisbon, Portugal Permissive open source license 4

    @clairegiordano
  24. PGConfEU 2018 | Lisbon, Portugal 24

  25. PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    courtesy of Peter van Hardenberg, The Illustrated History of Postgres
  26. PGConfEU 2018 | Lisbon, Portugal PGConfEU 2018 | Lisbon, Portugal

    Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “
  27. PGConfEU 2018 | Lisbon, Portugal https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases PGConfEU 2018 | Lisbon,

    Portugal https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases
  28. PGConfEU 2018 | Lisbon, Portugal 5 Data Integrity Maintainability Trust

    Hardened @clairegiordano
  29. PGConfEU 2018 | Lisbon, Portugal 6 Trend away from NoSQL

    @clairegiordano
  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
  31. PGConfEU 2018 | Lisbon, Portugal 7 Heroku helped to popularize

    Postgres @clairegiordano
  32. PGConfEU 2018 | Lisbon, Portugal @clairegiordano 8 Timing of JSON

    & JSONB support
  33. PGConfEU 2018 | Lisbon, Portugal 9 PostGIS is the “industry

    standard spatial database” @clairegiordano
  34. PGConfEU 2018 | Lisbon, Portugal

  35. PGConfEU 2018 | Lisbon, Portugal

  36. PGConfEU 2018 | Lisbon, Portugal 10 Extension APIs @clairegiordano

  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 “
  38. PGConfEU 2018 | Lisbon, Portugal

  39. PGConfEU 2018 | Lisbon, Portugal

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

    foreign data wrappers! postgresql-topn & so many many more
  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!
  42. PGConfEU 2018 | Lisbon, Portugal Because Postgres @citusdata @clairegiordano github.com/citusdata/citus

    please be sure to add a star to our github repo!