$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
Technology
2
450

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

See All by Citus Data
Adding PG15 Support to Citus Extension: Strategies and Lessons Learned | PGCon 2023 | Abdullah Hanefi Onaldi & Naisila Puka
citusdata
0
29
Postgres without SQL: Natural language queries using GPT-3 & Rust | Citus Con: An Event for Postgres 2023 | Jelte Fennema
citusdata
2
72
KEYNOTE: The Distributed PostgreSQL Problem & How Citus Solves it | Citus Con 2023 | Marco Slot
citusdata
0
76
Citus from the Customer eyes | Citus Con: An Event for Postgres 2023 | Sai Srirampur
citusdata
1
46
Takeaways from the First 6 Months of Hacking on Postgres | PGConf EU 2022 | Melih Mutlu
citusdata
1
250
Building Distributed PostgreSQL Apps with Citus 11 | PGConf EU 2022 | Charles Feddersen
citusdata
0
81
Postgres load balancing is secretly broken-the cancellation problem | Uptime 2022 | Jelte Fennema
citusdata
1
92
Citus Hyperscale Overview | CI&T Data Week | Leandro Santana
citusdata
2
260
Citus 10 Open Source & Columnar Storage for Postgres | contributing today | Claire Giordano & Nils Dijk
citusdata
2
460

Other Decks in Technology

See All in Technology
Cloud Security Day 2023パネルディスカッション資料
coconala_engineer
0
160
The Future of encoding/json
iamshunta
2
260
uGUI の自動操作の考え方と操作方法
orgachem
PRO
0
580
サービスの1等地ホーム画面改善と効果的なステークホルダーマネジメント / Improvement of Prime Location Home Screen for Services and Effective Stakeholder Management
rilmayer
0
180
Micro Frontends for Java Microservices - SF JUG 2023
mraible
PRO
1
200
Amazon Bedrock を利用したAIチャットボット開発
yukimatsuyoshi
1
460
論文紹介: Improving Implicit Feedback-Based Recommendation through Multi-Behavior Alignment(Xin Xin et al., 2023)
hakubishin3
0
180
Honoが良さそう🔥
is_ryo
0
180
AWS Security Hubを有効化したけど見てない人に向けたDevSecOpsの実現方法 / #kayac_andpad_event
muziyoshiz
0
180
ココナラでエンジニアマネージャーをやってみた！
coconala_engineer
1
120
コロプラ_SRE_LCE_ゲームバックエンド_性能との戦い
colopl
0
150
Japan.R2023_いろんな可視化ツールあるけどggplotて何がいいの？- 複数ツールで比較してみた！-
wakamatsu_takumu
1
470

Featured

See All Featured
Unsuck your backbone
ammeep
660
56k
It's Worth the Effort
3n
180
27k
We Have a Design System, Now What?
morganepeng
41
6.5k
Fashionably flexible responsive web design (full day workshop)
malarkey
396
64k
Building Better People: How to give real-time feedback that sticks.
wjessup
349
18k
What's in a price? How to price your products and services
michaelherold
236
10k
Designing on Purpose - Digital PM Summit 2013
jponch
108
6.2k
A designer walks into a library…
pauljervisheath
199
22k
The Illustrated Children's Guide to Kubernetes
chrisshort
26
45k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
185
15k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
225
51k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
1
890

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