$30 off During Our Annual Pro Sale. View Details »

Fibonacci Spirals & 21 Ways to Contribute to Postgres | FOSDEM 2020 | Claire Giordano

Citus Data
February 02, 2020

Fibonacci Spirals & 21 Ways to Contribute to Postgres | FOSDEM 2020 | 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.

Citus Data

February 02, 2020
Tweet

More Decks by Citus Data

Other Decks in Technology

Transcript

  1. @clairegiordano
    FIBONACCI SPIRALS &
    21 WAYS TO CONTRIBUTE TO
    POSTGRES—BEYOND CODE
    Claire Giordano
    @clairegiordano • @citusdata • @microsoft

    View Slide

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

    View Slide

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

    View Slide

  4. @clairegiordano
    2
    3
    5
    8
    13
    21
    FIBONACCI SPIRAL: 1, 1, 2, 3, 5, 8, 13, 21, 34, …

    View Slide

  5. @clairegiordano
    What does
    Fibonacci have to
    do with
    contributing to
    Postgres?

    View Slide

  6. @clairegiordano

    View Slide

  7. @clairegiordano

    View Slide

  8. @clairegiordano
    Source: Reddit

    View Slide

  9. @clairegiordano
    @clairegiordano
    21 WAYS TO
    CONTRIBUTE TO
    POSTGRES—
    BEYOND CODE

    View Slide

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

    View Slide

  11. @clairegiordano
    Source: Josh Berkus on Slideshare.net: 50 Ways to Love Your Project
    @clairegiordano
    Turns out, Josh Berkus gave a similar talk in 2013

    View Slide

  12. @clairegiordano
    12
    Attend conferences. Learn, participate, share
    1
    Source: fosdem.org/2020

    View Slide

  13. @clairegiordano
    13
    Source: @PostgreSQLNL, @OptimaDataBV
    z
    Lots of ways to support local meetups
    2

    View Slide

  14. @clairegiordano
    Source: pgibz.io
    Share your expertise—give a conference talk
    3

    View Slide

  15. @clairegiordano
    Post your slides online
    # of digital views can > # attendees
    • speakerdeck.com
    • slideshare.net
    • conference sites
    4
    @clairegiordano
    Source: speakerdeck.com/clairegiordano

    View Slide

  16. @clairegiordano
    @clairegiordano Source: 2020.pgday.paris
    5
    > Single-track, 1-day, local
    > More affordable
    > Easy access
    Start a local PGDay in your area
    > Single-track, 1-day, local
    > More affordable
    > Easy access

    View Slide

  17. @clairegiordano
    @clairegiordano Source: pgday.cl/2019/
    5

    View Slide

  18. @clairegiordano
    @clairegiordano
    5
    Source: pgdaysf.org

    View Slide

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

    View Slide

  20. @clairegiordano
    7
    Syndicate to
    Planet Postgres
    to increase reach of your posts
    @planetpostgres on Twitter, too
    @clairegiordano

    View Slide

  21. @clairegiordano
    7
    Syndicate to
    Planet Postgres
    to increase reach of your posts
    @planetpostgres on Twitter, too
    @clairegiordano Source: postgresql.org

    View Slide

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

    View Slide

  23. @clairegiordano
    Write Books
    make it easier for
    newcomers to use
    Postgres
    8
    @clairegiordano
    Source: sql-performance-explained.com

    View Slide

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

    View Slide

  25. @clairegiordano
    10
    @clairegiordano
    Use Video to show what
    Postgres can do
    Some people learn better via
    video
    Source: youtube.com/watch?v=-cbT64D9KFk

    View Slide

  26. @clairegiordano
    10
    @clairegiordano
    Title
    Thumbnail
    Description
    Bookmarks
    Links
    Good video metadata
    will help your video get
    discovered
    Some people learn better via
    video

    View Slide

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

    View Slide

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

    View Slide

  29. @clairegiordano
    Say thank you.
    If you like someone’s
    work, praise it.
    • Privately. Publicly. Both.
    • Especially junior & new people
    • Not just luminaries & friends
    13
    @clairegiordano

    View Slide

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

    View Slide

  31. @clairegiordano
    @clairegiordano
    15
    Source: postgresql.org
    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.”

    View Slide

  32. @clairegiordano
    @clairegiordano
    15
    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.”

    View Slide

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

    View Slide

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

    View Slide

  35. @clairegiordano
    Stickers are a thing
    Promote your Postgres projects too
    Spark unexpected conversations
    17

    View Slide

  36. @clairegiordano
    @clairegiordano
    Use your design skills
    • Citus elicorn
    • Louise Grandjonc’s crocodile
    • Postgres Activity Book
    Graphics & visuals pull people in
    Source: Citus “sharded” elicorn
    18

    View Slide

  37. @clairegiordano
    @clairegiordano
    Use your design skills
    • Citus elicorn
    • Louise Grandjonc’s crocodile
    • Postgres Activity Book
    Graphics & visuals pull people in
    18
    Source: www.Instagram.com/zimmoriarty/

    View Slide

  38. @clairegiordano
    @clairegiordano
    Use your design skills
    • Citus elicorn
    • Louise Grandjonc’s crocodile
    • Postgres Activity Book
    Graphics & visuals pull people in
    18

    View Slide

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

    View Slide

  40. @clairegiordano
    Source: Twitter @DevrimGunduz, FOSDEM’19
    @clairegiordano
    Evangelize at your local university (or alma mater)
    20

    View Slide

  41. @clairegiordano
    Make people feel
    welcome
    Being “welcoming” is
    one step further
    than being “open”
    21
    @clairegiordano

    View Slide

  42. @clairegiordano
    21 Ways to Contribute to Postgres—Beyond Code
    @clairegiordano
    1. Attend Conferences
    2. Meetups &
    User Groups
    3. Give a Talk
    4. Post Slides 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. Doc Feedback
    17. Stickers
    18. Design skills
    19. #sketchnotes
    20. University outreach
    21. Welcome people in

    View Slide

  43. @clairegiordano

    View Slide

  44. @clairegiordano
    Merci / Dank u
    @clairegiordano • @citusdata • @microsoft

    View Slide