Why PostgreSQL Why This Database Why Now? | 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.

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!