How to get involved with Postgres without being a PG Expert | Claire Giordano

How to get involved with Postgres without being a PG Expert | Claire Giordano | PASS Data Summit 2023

Slide 1

Slide 1 text

How to get involved with Postgres without being a PG expert? Claire Giordano She/Her Head of Postgres community efforts @ Microsoft

Slide 2

Slide 2 text

Claire Open source champion @clairegiordano [email protected] citusdata.com/blog/authors/claire-giordano Microsoft Head of Postgres & Citus open-source community efforts at Microsoft. Alum of Citus Data, Amazon, Sun Microsystems, and Brown University CS. Conference speaker at PGConf EU, FOSDEM, PGConf NYC, Nordic PGDay, & Swiss PGDay. Chair of Talk Selection Team for Citus Con: An Event for Postgres. Loves sailing in Greece. He/Him Giordano @clairegiordano

Slide 3

Slide 3 text

#PASSDataCommunitySummit You’re just starting to use Postgres Who is this Postgres talk for? You’re just starting to use Postgres

Slide 4

Slide 4 text

#PASSDataCommunitySummit You’re just starting to use Postgres Who is this Postgres talk for? You’re just starting to use Postgres New job in a Postgres company! New job in a Postgres company!

Slide 5

Slide 5 text

#PASSDataCommunitySummit Job search, looking for a “side gig” You’re just starting to use Postgres Who is this Postgres talk for? You’re just starting to use Postgres New job in a Postgres company! New job in a Postgres company! Looking for a “side gig”

Slide 6

Slide 6 text

#PASSDataCommunitySummit You have a PG problem to solve, some kind of “itch” Job search, looking for a “side gig” You’re just starting to use Postgres Who is this Postgres talk for? You’re just starting to use Postgres New job in a Postgres company! New job in a Postgres company! Looking for a “side gig” You have Postgres friends & you want to get involved

Slide 7

Slide 7 text

Slide 8

Slide 8 text

#PASSDataCommunitySummit Once Upon A Time... 6.5 years ago, I was in a “new job in a Postgres company”

Slide 9

Slide 9 text

#PASSDataCommunitySummit All these different ways of contributing to Postgres add value Just like racing sailboats Source: Livestream of Rolex Big Boats Racing Series, Sep 2021 (my son was on the crew!) #PASSDataCommunitySummit

Slide 10

Slide 10 text

#PASSDataCommunitySummit Looks like he’s paying attention to the spinnaker? That’s my son Source: Livestream of Rolex Big Boats Racing Series, Sep 2021 (my son was on the crew!) #PASSDataCommunitySummit

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

#PASSDataCommunitySummit This is how Josh drew “Contribution Pie” in 2013

Slide 13

Slide 13 text

#PASSDataCommunitySummit • Time • Treasure ($$$) • Talent (unique skills) I know a guy who used to say parents have 3 ways to support their children’s universities (beyond tuition) Three “T”s

Slide 14

Slide 14 text

#PASSDataCommunitySummit Ways to Get Involved With Postgres, in today’s talk SHARE FEEDBACK INSPIRE CONVERSATION DONATE

Slide 15

Slide 15 text

#PASSDataCommunitySummit Ways to Get Involved With Postgres, in today’s talk SHARE FEEDBACK DONATE 1. User experiences 2. Today I Learned / My First 6 Months 3. Video Demos 4. Social Media CONVERSATION INSPIRE 5. Online Q&A 6. Hallway Track @ Events 7. Support Meetups 8. Doc feedback 9. Report bugs 10. Test new releases 11. Language skills 12. Design skills 13. #Sketchnotes skills 14. Sponsorships 15. Shine light on others 16. Say thank you!

Slide 16

Slide 16 text

Share your user experiences 1

Slide 17

Slide 17 text

#PASSDataCommunitySummit 1 • Blog posts • Talks • Podcast interviews • Twitter/Mastodon/Threads • PGSQL Phriday blogs • Official “case studies" Share your user experiences

Slide 18

Slide 18 text

#PASSDataCommunitySummit 1 1. Headlines 2. Scannability 3. Diagrams 4. Tables 5. Bullets 6. Code blocks REMEMBER: • Blog posts • Talks • Podcast interviews • Twitter/Mastodon/Threads • PGSQL Phriday Blogs • Official “case studies” Tips for telling user stories

Slide 19

Slide 19 text

#PASSDataCommunitySummit with tips & checklists More Tips: My talk from PGConfEU 2022 Source: aka.ms/claire-slides-blogging-tips-pgconfeu2022 #PASSDataCommunitySummit 1

Slide 20

Slide 20 text

#PASSDataCommunitySummit ~83.2 K views & growing Example: Pouria Hadjibagheri of UKHSA co-authored post on implementation of UK COVID-19 dashboard Source: aka.ms/blog-ukcovid19-dashboard-citus #PASSDataCommunitySummit 1

Slide 21

Slide 21 text

Today I Learned / My First 6 Months 2

Slide 22

Slide 22 text

Example: “Today I Learned” 2 So much to learn from Simon Willison’s “work in public” Source: til.simonwillison.net/

Slide 23

Slide 23 text

477 Example: “Today I Learned” 2 Has published a TON of these TILs since started in ~2020 I think? Source: til.simonwillison.net/

Slide 24

Slide 24 text

Example: My First 6 Months 2

Slide 25

Slide 25 text

Some people learn better via video 3

Slide 26

Slide 26 text

#PASSDataCommunitySummit How you solved a problem, what you learned, how you solved something Use Video to show how you use Postgres Source: aka.ms/how-citus-distributes-postgres #PASSDataCommunitySummit 3

Slide 27

Slide 27 text

#PASSDataCommunitySummit • Titles should be compelling • Frontload w/ most important words because...... • YouTube truncates title @ 70 chars Good video metadata will help your video get discovered #PASSDataCommunitySummit 3 Thumbnail Description Hashtags Bookmarks Links Chapters Title

Slide 28

Slide 28 text

Promoting on social media reaches more ppl, grows ecosystem 4

Slide 29

Slide 29 text

#PASSDataCommunitySummit your learnings, user stories, meetups, talks attended, TIL, QOTD, OH, how-to, new releases So many PG things to signal boost on social 4

Slide 30

Slide 30 text

#PASSDataCommunitySummit • Mastodon • Twitter • LinkedIn • Threads Where to promote & share? 4 • Slack • Reddit • Discord • IRC

Slide 31

Slide 31 text

Join in the online Q&A 5

Slide 32

Slide 32 text

#PASSDataCommunitySummit • PostgreSQL Slack • IRC • Stack Overflow #postgresql • Reddit: PostgreSQL, SQL, ... Join in online Q&A to ask questions, share your perspective 5

Slide 33

Slide 33 text

Attend Conferences 6

Slide 34

Slide 34 text

#PASSDataCommunitySummit • Meet people / Make friends • Volunteer to help with event • Great way to learn about PG Be part of Hallway Track @ Conferences 6

Slide 35

Slide 35 text

Run, host, & support local meetups 7

Slide 36

Slide 36 text

#PASSDataCommunitySummit • Need organizers • Your company can donate meeting space • Need $$$ for food/drink • Need speakers Meetups always need help 7 Source: @PostgreSQLNL, @OptimaDataBV

Slide 37

Slide 37 text

Docs feedback 8

Slide 38

Slide 38 text

#PASSDataCommunitySummit • Clarify • Fix ambiguities • Bring the “new person” perspective to docs & help improve for other newbies! Docs feedback is a gift too! 8

Slide 39

Slide 39 text

#PASSDataCommunitySummit “Submit correction” link @ bottom of each docs page takes you here 8 Source: postgresql.org

Slide 40

Slide 40 text

Report bugs with Postgres 9

Slide 41

Slide 41 text

#PASSDataCommunitySummit Report bugs with Postgres 9 Source: postgresql.org 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 42

Slide 42 text

#PASSDataCommunitySummit WHERE to report bugs 9 Source: postgresql.org 1. Mailing list, or 2. Bug report web-form here: postgresql.org/account/submitbug/ 3. Unless it’s a security issue!

Slide 43

Slide 43 text

#PASSDataCommunitySummit Security issues are special 9

Slide 44

Slide 44 text

User testing 10

Slide 45

Slide 45 text

#PASSDataCommunitySummit • Your own applications • New PG Beta, RC releases • New features • Also, tell the PG community when things work! User testing 10 To: pgsql-hackers Lists: pgsql-hackers Just tested our application FOOBAR (a multi-tenant SaaS application) with the RC 1 release of PG16 and wanted to let y’all that it worked! Imaginary email....

Slide 46

Slide 46 text

Translations 11

Slide 47

Slide 47 text

#PASSDataCommunitySummit • Mailing list: pgsql-translators • More info: babel.postgresql.org • Instructions in Postgres docs: “Native Language support” Help with message translations #PASSDataCommunitySummit 11

Slide 48

Slide 48 text

#PASSDataCommunitySummit • Italian was “saved at the last minute” because of this call for help during PG 15 Translations really need help! #PASSDataCommunitySummit 11

Slide 49

Slide 49 text

#PASSDataCommunitySummit • for message translations • to create nice/friendly tooling • to coordinate translation of documentation Says Álvaro Herrera: “Volunteers = welcome!” #PASSDataCommunitySummit 11 Postgres 11 had 14 translations Postgres 16 has just 11 “Survivors” Czech French French German German Italian Italian Japanese Japanese Korean Korean Polish Portuguese PRC Chinese Russian Russian Spanish Spanish Swedish Swedish Turkish Vietnamese Greek, Georgian, Ukrainian

Slide 50

Slide 50 text

Graphics & visuals pull people in 12

Slide 51

Slide 51 text

#PASSDataCommunitySummit PostgreSQL 16 release artwork design contest that Mark Wong ran on 99designs Use your design skills /Graphics & visuals pull people in #PASSDataCommunitySummit 12 Source: https://99designs.com/illustrations/contests/postgresql-v-release-artwork-1239210 Winner

Slide 52

Slide 52 text

#PASSDataCommunitySummit Use your design skills /Graphics & visuals pull people in #PASSDataCommunitySummit 12

Slide 53

Slide 53 text

#PASSDataCommunitySummit Use your design skills /Graphics & visuals pull people in #PASSDataCommunitySummit 12 “Elicorn” = Citus open source mascot.

Slide 54

Slide 54 text

#PASSDataCommunitySummit Stickers are a thing in developer world #PASSDataCommunitySummit 12 • Promote your Postgres projects too • Spark unexpected conversations

Slide 55

Slide 55 text

Use “Sketchnotes” 13

Slide 56

Slide 56 text

#PASSDataCommunitySummit Combine words, lettering styles, color, sketches, bullets Use “Sketchnotes” to share your learnings 13 Source: twitter.com/reverentgeek

Slide 57

Slide 57 text

#PASSDataCommunitySummit 1) reinforce learning 2) give you an asset you can share! Visual note-taking aka “sketchnotes” do 2 things: reinforce learning & give you an asset you can share! 13 Source: twitter.com/krisztaszerovay

Slide 58

Slide 58 text

Sponsorships 14

Slide 59

Slide 59 text

#PASSDataCommunitySummit Sponsor Conferences & PGDays #PASSDataCommunitySummit 14 Call for Sponsorships is now open!

Slide 60

Slide 60 text

Recognition matters 15

Slide 61

Slide 61 text

#PASSDataCommunitySummit • Privately. Publicly. Both. • Beyond code • Not just developers Shine a bright light on other people’s work. Recognition matters. 15

Slide 62

Slide 62 text

#PASSDataCommunitySummit • Human side of Postgres • + databases, open source • + PG extensions too Example: Path To Citus Con podcast for developers who love Postgres 15

Slide 63

Slide 63 text

Working in public PostGIS How I got started Conference talks Favorite ways to learn For app developers Topics: aka.ms/PathToCitusCon A new podcast for developers who love Postgres Path to Citus Con 15

Slide 64

Slide 64 text

#PASSDataCommunitySummit p.s. Ratings & Reviews help new listeners discover (& help podcasters know it’s useful!) 15 aka.ms/PathToCitusCon

Slide 65

Slide 65 text

Say thank you 16

Slide 66

Slide 66 text

#PASSDataCommunitySummit • Privately. Publicly. Both. • Especially junior & new people • Not just luminaries & friends Say thank you. If you like someone’s work, praise it. 16

Slide 67

Slide 67 text

#PASSDataCommunitySummit Say thank you to conference speakers whose talks you have learned from You will MAKE. THEIR. DAY. 16

Slide 68

Slide 68 text

Don’t forget Postgres extensions! 17

Slide 69

Slide 69 text

#PASSDataCommunitySummit Might be easier to get involved with a smaller ecosystem project first 17 See my talk from PGConf NYC 2023 https://aka.ms/Claire-PGConfNYC2023-extensions

Slide 70

Slide 70 text

#PASSDataCommunitySummit 17 Ways to Get Involved With Postgres SHARE FEEDBACK DONATE 1. User experiences 2. Today I Learned / My First 6 Months 3. Video Demos 4. Social Media CONVERSATION INSPIRE 5. Online Q&A 6. Hallway Track @ Events 7. Support Meetups 8. Doc feedback 9. Report bugs 10. Test new releases 11. Language skills 12. Design skills 13. #Sketchnotes skills 14. Sponsorships 15. Shine light on others 16. Say thank you! EXTENSIONS 17. Check out Extensions!

Slide 71

Slide 71 text

#PASSDataCommunitySummit Thanks & credits & inspiration go to • Josh Berkus • Samay Sharma • Thomas Munro • Rob Treat • Melanie Plageman • Simon Willison • Lætitia Avrot • Isaac Alves • Marco Slot • Ryan Booz • Charles Feddersen

Slide 72

Slide 72 text

#PASSDataCommunitySummit Thanks to all the Postgres speakers @ #PASSDataSummit I’m learning from!

Slide 73

Slide 73 text

Thank you Claire Giordano [email protected] @AzureDBPostgres @citusdata @clairegiordano @clairegiordano and be sure to check out my new podcast @ aka.ms/PathToCitusCon Path To Citus Con for developers who love Postgres