Slide 1

Slide 1 text

@clairegiordano FIBONACCI SPIRALS & WAYS TO CONTRIBUTE TO POSTGRES—BEYOND CODE Claire Giordano @clairegiordano • @citusdata • @AzureDBPostgres

Slide 2

Slide 2 text

@clairegiordano Leonardo Pisano Bigollo (1170–1240) Source: Wikimedia Commons [Public Domain]

Slide 3

Slide 3 text

@clairegiordano 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89... FIBONACCI SEQUENCE Source: Wikimedia Commons [Public Domain]

Slide 4

Slide 4 text

@clairegiordano 2 3 5 8 13 21 What do Fibonacci spirals have to do with contributing to Postgres? 1, 1, 2, 3, 5, 8, 13, 21, 34, …

Slide 5

Slide 5 text

@clairegiordano

Slide 6

Slide 6 text

@clairegiordano

Slide 7

Slide 7 text

@clairegiordano @clairegiordano WAYS TO CONTRIBUTE TO POSTGRES— BEYOND CODE

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

@clairegiordano Josh Berkus gave a similar talk in ~2013 Source: Josh Berkus on GitHub: https://jberkus.github.io/pdf_presos/50_ways.pdf

Slide 10

Slide 10 text

@clairegiordano This is how Josh drew ”Contribution Pie” in 2013

Slide 11

Slide 11 text

@clairegiordano Why Beyond Code? Just like racing sailboats Every person in the crew—every role—matters Source: Livestream of Rolex Big Boats Racing Series, Sep 2021 (my son is on the crew!)

Slide 12

Slide 12 text

@clairegiordano 18 Ways to Contribute to Postgres—Beyond Code 1. Write 2. Give a Talk 3. Write a book 4. Video 5. Outreach to other dev communities 6. User stories 7. Promote, tweet too 8. Run & support Meetups 9. Organize a PG event 10. Shine light on others 11. Report bugs 12. User testing of stuff 13. Translations 14. Doc feedback 15. Stickers 16. Design skills 17. #sketchnotes 18. Welcome people in, & answer lots of questions @clairegiordano

Slide 13

Slide 13 text

@clairegiordano Share learnings & expertise Shine light on value of Postgres 1 Write a blog post Publish an article

Slide 14

Slide 14 text

@clairegiordano 1 Syndicate to Planet Postgres • to increase reach of your posts • @planetpostgres on Twitter, too

Slide 15

Slide 15 text

@clairegiordano Share your expertise—give a talk Source: fosdem.org/2020 2

Slide 16

Slide 16 text

@clairegiordano @clairegiordano CLAIRE15 ~ a 15% off discount on any edition Source: theartofpostgresql.com 3 Write a Book make it easier for newcomers to use Postgres

Slide 17

Slide 17 text

@clairegiordano Write a Book make it easier for newcomers to use Postgres @clairegiordano Source: sql-performance-explained.com 3

Slide 18

Slide 18 text

@clairegiordano 4 @clairegiordano Use Video to show what Postgres can do Some people learn better via video Source: aka.ms/how-citus-distributes-postgres

Slide 19

Slide 19 text

@clairegiordano 4 Good video metadata will help your video get discovered don’t forget to use meaningful keywords in the filename! Thumbnail Description 3 hashtags Bookmarks Links Chapters Title

Slide 20

Slide 20 text

@clairegiordano Outreach to your other dev communities 5 Source: Louise Grandjonc talk at DjangoCon US YouTube, DjangoCon 2019

Slide 21

Slide 21 text

@clairegiordano Interview your users & tell their stories • Story • Headlines • Diagrams • Big Metrics • “Pull quotes” 6

Slide 22

Slide 22 text

@clairegiordano Interview your users & tell their stories • ~77.9K views • aka.ms/blog-ukcovid19- dashboard-citus 6 Example: Co-authored post w/ Pouria Hadjibagheri of UKHSA on implementation of UK COVID-19 dashboard

Slide 23

Slide 23 text

@clairegiordano 7 If you build it, they will NOT come. PROMOTE.

Slide 24

Slide 24 text

@clairegiordano Promote on Twitter learnings, ideas, talks, meetups, TIL, QOTD, OH, how-to 7

Slide 25

Slide 25 text

@clairegiordano Promote on Twitter new events, too! 7

Slide 26

Slide 26 text

@clairegiordano 26 Source: @PostgreSQLNL, @OptimaDataBV z Run, host, & support local meetups 8

Slide 27

Slide 27 text

@clairegiordano Organize a Postgres event 9 Source: fosdem.org/2020 38 18 Livestream talks 20 On-demand talks 15 Postgres deep-dives Sessions

Slide 28

Slide 28 text

@clairegiordano Shine a bright light on other people’s work. Recognition matters. • Privately. Publicly. Both. • Beyond code • Not just developers @clairegiordano 10 created by Andreas Scherbaum

Slide 29

Slide 29 text

@clairegiordano 11 Report bugs with Postgres When you find a bug with Postgres we want to hear about it.” “ “ Your bug reports play an important part in making PostgreSQL more reliable.” Source: postgresql.org

Slide 30

Slide 30 text

@clairegiordano 11 Source: postgresql.org WHERE to report bugs When you find a bug with Postgres we want to hear about it.” “ “ Your bug reports play an important part in making PostgreSQL more reliable.”

Slide 31

Slide 31 text

@clairegiordano User testing your own applications! new features recent docs updates –––tell the PG community when things work 12 Imaginary email.... To: pgsql-hackers Lists: pgsql-hackers Just tested our application FOOBAR with the beta release candidate for Postgres 15 and wanted to let y’all that it worked!

Slide 32

Slide 32 text

@clairegiordano Help with message translations Mailing list: pgsql-translators More info: babel.postgresql.org Instructions in Postgres docs: “Native Language support” 13

Slide 33

Slide 33 text

@clairegiordano Submit corrections to documentation Clarify Disambiguate Help new people understand 14 @clairegiordano Source: postgresql.org

Slide 34

Slide 34 text

@clairegiordano Submit corrections to documentation Clarify Disambiguate Help new people understand 14 @clairegiordano Source: postgresql.org

Slide 35

Slide 35 text

@clairegiordano Stickers are a thing Promote your PG projects Spark unexpected conversations 15

Slide 36

Slide 36 text

@clairegiordano Use your design skills • Citus elicorn • Citus Con pink elephant • Postgres Activity Book Graphics & visuals pull people in Source: Citus “sharded” elicorn mascot 16

Slide 37

Slide 37 text

@clairegiordano Use your design skills • Citus elicorn • Citus Con pink elephant • Postgres Activity Book Graphics & visuals pull people in 16

Slide 38

Slide 38 text

@clairegiordano Use your design skills • Citus elicorn • Citus Con pink elephant • Postgres Activity Book Graphics & visuals pull people in 16

Slide 39

Slide 39 text

@clairegiordano Use “Sketchnotes” to share your learnings Combine words, lettering styles, color, sketches, bullets 17 @clairegiordano Source: twitter.com/reverentgeek

Slide 40

Slide 40 text

@clairegiordano Make people feel welcome Answer questions. Lots of questions. Slack. IRC. Stack Overflow. Mailing lists. @clairegiordano 18

Slide 41

Slide 41 text

@clairegiordano 18 Ways to Contribute to Postgres—Beyond Code 1. Write 2. Give a Talk 3. Write a book 4. Video 5. Outreach to other dev communities 6. User stories 7. Promote, tweet too 8. Run & support Meetups 9. Organize a PG event 10. Shine light on others 11. Report bugs 12. User testing of stuff 13. Translations 14. Doc feedback 15. Stickers 16. Design skills 17. #sketchnotes 18. Welcome people in, & answer lots of questions @clairegiordano

Slide 42

Slide 42 text

@clairegiordano

Slide 43

Slide 43 text

@clairegiordano Thank you @citusdata • @CitusCon • @AzureDBPostgres @clairegiordano