Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How to get involved with Postgres without being...

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

Slides from a talk about ways to get involved with the PostgreSQL open source database even if you're not a PG expert—presented at the PASS Data Community Summit in Seattle in Nov 2023. Abstract: Over 700 developers have contributed over 54,000 commits to Postgres: their expertise, dedication, and skill are big factors in the increasing popularity of Postgres. But what if you’re not a Postgres developer yet, are there things you can do to help the Postgres community? Are there ways to get involved in the PG community without being a Postgres expert?

In this updated version of the talk Claire gave at FOSDEM and at Citus Con: An Event for Postgres, you'll learn about 17 ways you can get involved in the Postgres community, beyond code.

From docs to translations to advocacy to demos—as well as sharing what you’ve learned as a Postgres user story—there are many ways to contribute. And just like sailboat racing—in which every single person in the crew influences the final score—all these different types of contributions to Postgres are valuable.

Claire Giordano

November 18, 2023
Tweet

More Decks by Claire Giordano

Other Decks in Technology

Transcript

  1. How to get involved with Postgres without being a PG

    expert? Claire Giordano She/Her Head of Postgres community efforts @ Microsoft
  2. 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
  3. #PASSDataCommunitySummit You’re just starting to use Postgres Who is this

    Postgres talk for? You’re just starting to use Postgres
  4. #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!
  5. #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”
  6. #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
  7. #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 Pivoting from another DB to Postgres & want to contribute
  8. #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
  9. #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
  10. #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
  11. #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!
  12. #PASSDataCommunitySummit 1 • Blog posts • Talks • Podcast interviews

    • Twitter/Mastodon/Threads • PGSQL Phriday blogs • Official “case studies" Share your user experiences
  13. #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
  14. #PASSDataCommunitySummit with tips & checklists More Tips: My talk from

    PGConfEU 2022 Source: aka.ms/claire-slides-blogging-tips-pgconfeu2022 #PASSDataCommunitySummit 1
  15. #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
  16. Example: “Today I Learned” 2 So much to learn from

    Simon Willison’s “work in public” Source: til.simonwillison.net/
  17. 477 Example: “Today I Learned” 2 Has published a TON

    of these TILs since started in ~2020 I think? Source: til.simonwillison.net/
  18. #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
  19. #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
  20. #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
  21. #PASSDataCommunitySummit • Mastodon • Twitter • LinkedIn • Threads Where

    to promote & share? 4 • Slack • Reddit • Discord • IRC
  22. #PASSDataCommunitySummit • PostgreSQL Slack • IRC • Stack Overflow #postgresql

    • Reddit: PostgreSQL, SQL, ... Join in online Q&A to ask questions, share your perspective 5
  23. #PASSDataCommunitySummit • Meet people / Make friends • Volunteer to

    help with event • Great way to learn about PG Be part of Hallway Track @ Conferences 6
  24. #PASSDataCommunitySummit • Need organizers • Your company can donate meeting

    space • Need $$$ for food/drink • Need speakers Meetups always need help 7 Source: @PostgreSQLNL, @OptimaDataBV
  25. #PASSDataCommunitySummit • Clarify • Fix ambiguities • Bring the “new

    person” perspective to docs & help improve for other newbies! Docs feedback is a gift too! 8
  26. #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.” “ “
  27. #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!
  28. #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....
  29. #PASSDataCommunitySummit • Mailing list: pgsql-translators • More info: babel.postgresql.org •

    Instructions in Postgres docs: “Native Language support” Help with message translations #PASSDataCommunitySummit 11
  30. #PASSDataCommunitySummit • Italian was “saved at the last minute” because

    of this call for help during PG 15 Translations really need help! #PASSDataCommunitySummit 11
  31. #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
  32. #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
  33. #PASSDataCommunitySummit Use your design skills /Graphics & visuals pull people

    in #PASSDataCommunitySummit 12 “Elicorn” = Citus open source mascot.
  34. #PASSDataCommunitySummit Stickers are a thing in developer world #PASSDataCommunitySummit 12

    • Promote your Postgres projects too • Spark unexpected conversations
  35. #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
  36. #PASSDataCommunitySummit • Privately. Publicly. Both. • Beyond code • Not

    just developers Shine a bright light on other people’s work. Recognition matters. 15
  37. #PASSDataCommunitySummit • Human side of Postgres • + databases, open

    source • + PG extensions too Example: Path To Citus Con podcast for developers who love Postgres 15
  38. 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
  39. #PASSDataCommunitySummit p.s. Ratings & Reviews help new listeners discover (&

    help podcasters know it’s useful!) 15 aka.ms/PathToCitusCon
  40. #PASSDataCommunitySummit • Privately. Publicly. Both. • Especially junior & new

    people • Not just luminaries & friends Say thank you. If you like someone’s work, praise it. 16
  41. #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
  42. #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!
  43. #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
  44. 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