Slide 1

Slide 1 text

@clairegiordan o Fibonacci Spirals & 21 Ways to Contribute to Postgres— Beyond Code Claire Giordano @clairegiordano @citusdata @microsoft PGConf.EU 2019

Slide 2

Slide 2 text

@clairegiordan o Leonardo Pisano Bigollo (1170–1240)

Slide 3

Slide 3 text

@clairegiordan o 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, … FIBONACCI SEQUENCE

Slide 4

Slide 4 text

@clairegiordan o FIBONACCI SPIRAL 1, 1, 2, 3, 5, 8, 13, 21, 34, … 2 3 5 8 13 21

Slide 5

Slide 5 text

@clairegiordan o What do Fibonacci spirals have to do with contributing to Postgres?

Slide 6

Slide 6 text

@clairegiordan o

Slide 7

Slide 7 text

@clairegiordan o

Slide 8

Slide 8 text

@clairegiordan o Source: Reddit

Slide 9

Slide 9 text

@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

Slide 10

Slide 10 text

@clairegiordan o Why ”Beyond Code”? What if… you’re not a developer?

Slide 11

Slide 11 text

@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

Slide 12

Slide 12 text

@clairegiordan o Attend conferences like this. Participate in the community. Learn—and share your learnings. Create a place where newcomers can learn. 1 @clairegiordano

Slide 13

Slide 13 text

@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

Slide 14

Slide 14 text

@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

Slide 15

Slide 15 text

@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

Slide 16

Slide 16 text

@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

Slide 17

Slide 17 text

@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

Slide 18

Slide 18 text

@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

Slide 19

Slide 19 text

@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

Slide 20

Slide 20 text

@clairegiordan o Write a blog. Publish an article. Share your learnings & expertise. Shine a light on value of Postgres. 6 @clairegiordano

Slide 21

Slide 21 text

@clairegiordan o Syndicate to PlanetPostgres to increase reach of your blog posts. @planetpostgres promotes on Twitter, too. 7 @clairegiordano

Slide 22

Slide 22 text

@clairegiordan o 7 Source: postgresql.org Syndicate to PlanetPostgres to increase reach of your blog posts. @planetpostgres promotes on Twitter, too. @clairegiordano

Slide 23

Slide 23 text

@clairegiordan o Write Books that make it easier for newcomers to use Postgres 8 @clairegiordano

Slide 24

Slide 24 text

@clairegiordan o Write Books that make it easier for newcomers to use Postgres 8 @clairegiordano

Slide 25

Slide 25 text

@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

Slide 26

Slide 26 text

@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

Slide 27

Slide 27 text

@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!

Slide 28

Slide 28 text

@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

Slide 29

Slide 29 text

@clairegiordan o Promote Postgres on Twitter 12 @clairegiordano

Slide 30

Slide 30 text

@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

Slide 31

Slide 31 text

@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

Slide 32

Slide 32 text

@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 “ “

Slide 33

Slide 33 text

@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 “ “

Slide 34

Slide 34 text

@clairegiordan o Submit corrections to documentation! Clarify. Disambiguate. Better help newcomers understand. 16 @clairegiordano Source: postgresql.org

Slide 35

Slide 35 text

@clairegiordan o Submit corrections to documentation! Clarify. Disambiguate. Better help newcomers understand. 16 @clairegiordano Source: postgresql.org

Slide 36

Slide 36 text

@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

Slide 37

Slide 37 text

@clairegiordan o 18 Use your design skills. Graphics & visuals pull people in. Meet—the Citus elicorn. @clairegiordano Source: Citus Data “sharded” elicorn

Slide 38

Slide 38 text

@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/

Slide 39

Slide 39 text

@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

Slide 40

Slide 40 text

@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

Slide 41

Slide 41 text

@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

Slide 42

Slide 42 text

@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

Slide 43

Slide 43 text

@clairegiordan o Make people feel welcome Being “welcoming” is 1 step further than being “open” 21 @clairegiordano

Slide 44

Slide 44 text

@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

Slide 45

Slide 45 text

@clairegiordan o

Slide 46

Slide 46 text

@clairegiordan o Thank You @clairegiordano | @citusdata | @microsoft Ideas/Suggestions? +1 or -1? Let me know :) PGConf.EU 2019