Fibonacci-Spirals and 21 Ways to Contribute to Postgres | PGConf EU 2019 | Claire Giordano

024d6a0dd14fb31c804969a57a06dfbe?s=47 Citus Data
October 16, 2019

Fibonacci-Spirals and 21 Ways to Contribute to Postgres | PGConf EU 2019 | Claire Giordano

Postgres is growing like gangbusters: in popularity, in adoption, and in the size of the ecosystem. And over 400 developers contribute code to Postgres today: their expertise, design chops, and skill are big factors in the increasing popularity of Postgres. But what if you’re not a developer? Are there things you can do to help grow the usage and popularity of Postgres? And are these non-code ways to contribute to Postgres important? Valued? Will they make a real difference?

If you love Postgres and want to help drive Fibonacci growth of the Postgres community, this talk is for you. I’ll walk through 21 different (and important) ways to contribute to Postgres—along with tips and resources for getting started.

024d6a0dd14fb31c804969a57a06dfbe?s=128

Citus Data

October 16, 2019
Tweet

Transcript

  1. 1.

    @clairegiordan o Fibonacci Spirals & 21 Ways to Contribute to

    Postgres— Beyond Code Claire Giordano @clairegiordano @citusdata @microsoft PGConf.EU 2019
  2. 3.

    @clairegiordan o 1, 1, 2, 3, 5, 8, 13, 21,

    34, 55, 89, … FIBONACCI SEQUENCE
  3. 4.
  4. 9.

    @clairegiordan o Hi, I’m Claire Giordano—and I’m a Principal PM

    Manager at Microsoft, by way of the recent Citus Data acquisition, where I was VP of Marketing. 21 Ways to Contribute to Postgres— Beyond Code @clairegiordano & drive Fibonacci growth
  5. 11.

    @clairegiordan o Right before I submitted talk proposal… Source: Josh

    Berkus on Slideshare.net: 50 Ways to Love Your Project DISCOVERED: Josh Berkus - similar talk in 2013
  6. 12.

    @clairegiordan o Attend conferences like this. Participate in the community.

    Learn—and share your learnings. Create a place where newcomers can learn. 1 @clairegiordano
  7. 13.

    @clairegiordan o Lots of ways to support local Meetups &

    User Groups, too. Attend. Give talks. Share learnings. Pay for food/drinks. Host in your company’s office space. @clairegiordano 2
  8. 14.

    @clairegiordan o Lots of ways to support local Meetups &

    User Groups, too. Attend. Give talks. Share learnings. Pay for food/drinks. Host in your company’s office space. @clairegiordano 2
  9. 15.

    @clairegiordan o Lots of ways to support local Meetups &

    User Groups, too. Attend. Give talks. Share learnings. Pay for food/drinks. Host in your company’s office space. @clairegiordano 2
  10. 16.

    @clairegiordan o Share your expertise—give a talk or tutorial at

    a conference. Meetups, too. Lightning talks, too. Most conference organizers WELCOME first-time presenters. @clairegiordano 3 PGConf.EU 2019
  11. 17.

    @clairegiordan o Post your slides online! Share them. Promote them

    # of digital pageviews can exceed # of attendees! > speakerdeck.com > slideshare.net > conference websites… 4 @clairegiordano
  12. 18.

    @clairegiordan o Start a local PGDay in your town. Single-track,

    1-day, local > More affordable > Easy access > All together, same room, all day 5 @clairegiordano Source: 2020.pgday.paris
  13. 19.

    @clairegiordan o @clairegiordano Source: www.pgday.cl/2019/ 5 Start a local PGDay

    in your town. Single-track, 1-day, local > More affordable > Easy access > All together, same room, all day
  14. 20.

    @clairegiordan o Write a blog. Publish an article. Share your

    learnings & expertise. Shine a light on value of Postgres. 6 @clairegiordano
  15. 21.

    @clairegiordan o Syndicate to PlanetPostgres to increase reach of your

    blog posts. @planetpostgres promotes on Twitter, too. 7 @clairegiordano
  16. 22.

    @clairegiordan o 7 Source: postgresql.org Syndicate to PlanetPostgres to increase

    reach of your blog posts. @planetpostgres promotes on Twitter, too. @clairegiordano
  17. 25.

    @clairegiordan o Create User Stories! About amazing things do w/

    Postgres Recipe: Story, headlines, diagrams, metrics, pull quotes 9 @clairegiordano Source: citusdata.com/customers/mixrank
  18. 26.

    @clairegiordan o Use Video to show what Postgres can do!

    Some people learn better via video. 10 @clairegiordano Source: www.youtube.com/watch?v=-cbT64D9KFk
  19. 27.

    @clairegiordan o Use Video to show what Postgres can do!

    Some people learn better via video. 10 @clairegiordano Title Thumbnail Description Bookmarks Links Don’t forget to post videos with good metadata!
  20. 28.

    @clairegiordan o If you build it, they will NOT come.

    Promote, promote, promote. Whether blog, video, user story, talk, or book! Help people discover. How to reach beyond inner circle? 11 @clairegiordano
  21. 29.

    @clairegiordan o Promote Postgres on Twitter <content, learnings, ideas, talks,

    meetups, TIL, QOTD, OH, how-to> 12 @clairegiordano
  22. 30.

    @clairegiordan o Say thank you. If you like someone’s work,

    praise it. Privately. Publicly. Both. Including junior people. New people. Not just luminaries. Not just friends. 13 @clairegiordano
  23. 31.

    @clairegiordan o Do you speak a non-English language? Help with

    message translations. Help Postgres content reach people in other languages. Mailing list: pgsql-translators More info: babel.postgresql.org 14
  24. 32.

    @clairegiordan o Report bugs with Postgres! When you find a

    bug with PostgreSQL we want to hear about it.” Your bug reports play an important part in making PostgreSQL more reliable.” @clairegiordano 15 Source: postgresql.org “ “
  25. 33.

    @clairegiordan o Report bugs with Postgres! When you find a

    bug with PostgreSQL we want to hear about it.” Your bug reports play an important part in making PostgreSQL more reliable.” @clairegiordano 15 Source: postgresql.org “ “
  26. 34.

    @clairegiordan o Submit corrections to documentation! Clarify. Disambiguate. Better help

    newcomers understand. 16 @clairegiordano Source: postgresql.org
  27. 35.

    @clairegiordan o Submit corrections to documentation! Clarify. Disambiguate. Better help

    newcomers understand. 16 @clairegiordano Source: postgresql.org
  28. 36.

    @clairegiordan o Promote Postgres with stickers. (Promote your PG projects,

    too.) Stickers are a thing for many devs. Stickers can spark conversation. @clairegiordano Source: my laptop 17
  29. 37.

    @clairegiordan o 18 Use your design skills. Graphics & visuals

    pull people in. Meet—the Citus elicorn. @clairegiordano Source: Citus Data “sharded” elicorn
  30. 38.

    @clairegiordan o Use your design skills. Graphics & visuals pull

    people in. Meet—the Citus elicorn. Louise Grandjonc’s Crocodile. 18 @clairegiordano Source: www.Instagram.com/zimmoriarty/
  31. 39.

    @clairegiordan o Use your design skills. Graphics & visuals pull

    people in. Meet—the Citus elicorn. Meet—Louise Grandjonc’s Owl. Meet—Postgres Activity Book. 18 @clairegiordano
  32. 40.

    @clairegiordan o Use “Sketchnotes” to share your learnings. Effective way

    to capture & communicate big takeaways Engages through combo of words, font styles, color, some images 19 @clairegiordano Source: twitter.com/reverentgeek
  33. 41.

    @clairegiordan o Reach out to evangelize at your local university

    (or alma mater). Offer to give a talk and share your learnings about the tricky problems you’ve solved by using Postgres (instead of…) 20 @clairegiordano Source: Twitter @DevrimGunduz, FOSDEM
  34. 42.

    @clairegiordan o Reach out to evangelize at your local university

    (or alma mater). Offer to give a talk and share your learnings about the tricky problems you’ve solved by using Postgres (instead of…) What will it take to make Postgres the de facto database taught in universities? 20 @clairegiordano Source: Twitter @DevrimGunduz, FOSDEM
  35. 43.

    @clairegiordan o Make people feel welcome Being “welcoming” is 1

    step further than being “open” 21 @clairegiordano
  36. 44.

    @clairegiordan o 1. Attend Conferences 2. Meetups & User Groups

    3. Give a Talk 4. PostSlides online 5. Start a PGDay 6. Blogs&articles 7. Syndicate to Planet Postgres 8. Write a book 9. User Stories 10. Bite-sized videos 11. Promote 12. Twitter 13. Say Thank You! 14. Translations 15. Report Bugs 16. DocFeedback 17. Stickers 18. Design skills 19. #sketchnotes 20. Universityoutreach 21. Welcome people in 21 Ways to Contribute—Beyond Code