Download as PDF, PPTX
De-mystifying contributing to PostgreSQL
- 1.
- 2. LOXODATA @l_avrot WHO Lætitia Avrot PostgreSQL consultantand teacher DBA PostgreSQL for more than 10 years (and also Oracle and SQL Server) @l_avrot
- 3. LOXODATA @l_avrot LOXODATA Company built on3 essential pillars PostgreSQL DevOps Cloud
- 4. LOXODATA @l_avrot WHAT Contributing to PostgreSQL ThePostgreSQL community The PostgreSQL projects and tools The story of my patch How you can help
- 5.
- 6.
- 7. LOXODATA @l_avrot The core team 5members Independant Act as project managers
- 8. LOXODATA @l_avrot Committers More or less15 members Have git push permissions Responsible for code quality
- 9. LOXODATA @l_avrot Developpers C code Need tocomply with Need to comment (a lot) style guide
- 10. LOXODATA @l_avrot Reviewers No need tobe a dev But technical background needed If you don't understand it, others won't
- 11. LOXODATA @l_avrot Translators No need tobe a dev Software messages Documentation Others (press releases...)
- 12. LOXODATA @l_avrot Advocacy Promote PostgreSQL use Shareinformations about PostgreSQL Regional press contacts
- 13. LOXODATA @l_avrot Associations Small to largegroups of users National or international
- 14.
- 15. LOXODATA @l_avrot Local User Groupsand Meetups User gathering Sharing thoughts, use cases, issues...
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25. LOXODATA @l_avrot The road map 1major release per year 1 minor release per quarter (minimum)
- 26. LOXODATA @l_avrot Commitfests 1 month long Whenmost patches are commited Needs a commitFest Manager
- 27.
- 28.
- 29.
- 30.
- 31. LOXODATA @l_avrot Mailing-lists Bug submission (usethe ) pgsql-novice for newcommers Special lists for associations and local groups pgsql-hackers (be carefull, these guys are SO chatty) form
- 32.
- 33. LOXODATA @l_avrot IRC Chanel #postgresql onirc.freenode.net Live chat with other PostgreSQL users Don't ask to ask, just ask!
- 34.
- 35. LOXODATA @l_avrot Twitter Stay in touchwith other PostgreSQL users Brand new community account : @postgresql
- 36. LOXODATA @l_avrot Other ways tostay in touch Postgres Postgres Forums (as ) Slack hangout stackexchange
- 37. LOXODATA @l_avrot Git if you don'tknow git, don't be afraid git clone git pull (--rebase) git diff Use the PostgreSQL Wiki page
- 38.
- 39. LOXODATA @l_avrot What's a patch? Source: Wikipedia A patch is a piece of software designed to update a computer program or its supporting data, to x or improve it.
- 40. LOXODATA @l_avrot My story Missing sectionin ALTER TABLE documentation Discussion with peers Bug reporting Patch creation with guru mentors Patch submission
- 41. LOXODATA @l_avrot Creating the patch PostgreSQLgit clone Copy/Paste missing section from CREATE TABLE to ALTER TABLE Re-building documentation from source code Building from source code Building documentation from source code
- 42. LOXODATA @l_avrot git diff With context Usethe wiki pageCreating clean patches Format your git diff output
- 43. LOXODATA @l_avrot But sometimes, eventhe best men don't follow instructions...
- 44. LOXODATA @l_avrot git diff withoutcontext to the left, git diff with context to the right
- 45. LOXODATA @l_avrot My submission Use theWiki pageSubmitting a patch
- 46.
- 47.
- 48.
- 49.
- 50. LOXODATA @l_avrot And another sectionwas missing!
- 51.
- 52.
- 53. LOXODATA @l_avrot ... Now Ican die without regret!
- 54. LOXODATA @l_avrot What next ? Correctingsome spelling errors in french translation Studying the code Observing revewing in January Commit fest Proposed conf talks (and got accepted each time for now)
- 55.
- 56. LOXODATA @l_avrot Simple contributor use PostgreSQL shareyour experience answer other users' questions
- 57. LOXODATA @l_avrot Great Contributor Create/help organizinguser group/Meetup Create/help organizing event Invest time/money in PostgreSQL Associations
- 58. LOXODATA @l_avrot Super Contributor Report bugs Createpatches Review patches
- 59.
- 60. LOXODATA @l_avrot It's all aboutyou You're already contributing So, next step ?
- 61.
- 62.
- 63. LOXODATA @l_avrot QUESTIONS ? The end We'rehiring! recrutement@loxodata.com Thanks to Dimitri, Greg, Vik, Robert and Alvaro for your patience and time Thanks to Frits Ahlefeldt, Freepik, Grzm, Alvaro Herrera, Pixabay and Xkcd.com for illustrations and photos