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.

Transcript

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. 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. NORDIC PGDay 2019 | Copenhagen
4. NORDIC PGDay 2019 | Copenhagen 4 @clairegiordano
5. NORDIC PGDay 2019 | Copenhagen 5 Peop le’s eyes ligh t up @clairegiordano
6. NORDIC PGDay 2019 | Copenhagen 6
7. NORDIC PGDay 2019 | Copenhagen 7 Peter Eisentraut
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.
9. NORDIC PGDay 2019 | Copenhagen Why PostgreSQL? Why This Database? Why Now? ? @clairegiordano
10. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen people have so much affection for PostgreSQL 10 reasons @clairegiordano
11. NORDIC PGDay 2019 | Copenhagen Open Source 1 @clairegiordano 0 Octocat icon courtesy of GitHub
12. NORDIC PGDay 2019 | Copenhagen
13. NORDIC PGDay 2019 | Copenhagen
14. NORDIC PGDay 2019 | Copenhagen
15. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen ECOSYSTEM
16. NORDIC PGDay 2019 | Copenhagen
17. NORDIC PGDay 2019 | Copenhagen Come for the code. Stay for the community.
18. NORDIC PGDay 2019 | Copenhagen Community 9 @clairegiordano Photo courtesy of @pgconfeu, Oct 2018 Lisbon
19. NORDIC PGDay 2019 | Copenhagen
20. NORDIC PGDay 2019 | Copenhagen
21. NORDIC PGDay 2019 | Copenhagen Source: https://www.pgcon.org/2016/schedule/events/890.en.html
22. NORDIC PGDay 2019 | Copenhagen 22
23. NORDIC PGDay 2019 | Copenhagen 23 @clairegiordano Not Oracle 8
24. NORDIC PGDay 2019 | Copenhagen Source: Manu Cornet. Bonkers World. http://bonkersworld.net/organizational-charts
25. NORDIC PGDay 2019 | Copenhagen 7 @clairegiordano Permissive license
26. NORDIC PGDay 2019 | Copenhagen 26
27. NORDIC PGDay 2019 | Copenhagen https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases
28. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen Forks make the community strong.” —Peter van Hardenberg, Illustrated History of Postgres “
29. NORDIC PGDay 2019 | Copenhagen 6 Trust Hardened Data Integrity Maintainability @clairegiordano
30. NORDIC PGDay 2019 | Copenhagen @clairegiordano
31. NORDIC PGDay 2019 | Copenhagen 5Trend away from NoSQL @clairegiordano
32. NORDIC PGDay 2019 | Copenhagen 32 Postgres is heating up Source: Hacker News Hiring Trends through Jan 2019 | hntrends.com Postgres MySQL MongoDB
33. NORDIC PGDay 2019 | Copenhagen 4 Heroku helped to popularize Postgres @clairegiordano
34. NORDIC PGDay 2019 | Copenhagen @clairegiordano 3 Timing of JSON & JSONB support
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
36. NORDIC PGDay 2019 | Copenhagen 36 Source: Paul Ramsey PGConfEU 2018 Keynote: Put some “where” in your WHERE clause; https://bit.ly/2NM3zqB
37. NORDIC PGDay 2019 | Copenhagen 37
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 “
39. NORDIC PGDay 2019 | Copenhagen And now……….. #1 reason
40. NORDIC PGDay 2019 | Copenhagen 1 Extension APIs @clairegiordano
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 “
42. NORDIC PGDay 2019 | Copenhagen Michael Stonebraker Source: Wikipedia
43. NORDIC PGDay 2019 | Copenhagen
44. NORDIC PGDay 2019 | Copenhagen
45. NORDIC PGDay 2019 | Copenhagen NORDIC PGDay 2019 | Copenhagen 45 Not everyone has to agree, up-front
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
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
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
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
50. NORDIC PGDay 2019 | Copenhagen Thank you! @citusdata @clairegiordano github.com/citusdata/citus @microsoft p.s. Socks & stickers