Rushabh plays a pivotal role in contributing to the PostgreSQL features development and patch reviews. He also contributes significantly to the EnterpriseDB propriety feature development. He wears the dual hat of a developer and of a committer for EDB Postgres Advanced Server. His experience spans over an extensive 17 years in the field of database development wherein he has used his expertise to develop databases like Oracle, PostgreSQL, EDB Postgres Advanced Server, and other RDBMS.View the profile
About the talk
PostgreSQL always encourages everyone to submit the patches for the features they would like to see in PostgreSQL and always encourages them to participate in the goal to make the PG as user-friendly. Any PostgreSQL user would like to get involved in the process or would like to contribute to back to the PG but the question is HOW?
One area where PG falls short is finding enough reviewers. Reviewing patch is a way to become familiar with PostgreSQL code as well as PostgreSQL processes through which feature/patch gets checked in. This talk focus on how one can contribute to the PG open source community (add feature, review patch, test patch, share expert opinion). This talk will try to explain how one can participate in reviewing the community patches.
This talk is for anyone who would like to contribute back to the PG community.
Good afternoon, everyone. I hope you guys are enjoying the conference. I'm in before starting anything. I really want to thank the organizers of this conference, where are such a beautiful event. So let's live for them buns. Yeah. And the measure of the only factor of successful of this event was the one element that supposed curse at school. So let's get for them as well. And success of both cases, Gorillaz depend on user developer, that means we care for our self. All right. Today, stories about like how we can get more than willing to
the community so that posted has become more and more success and we become the part of that. Again, this is not something about how you can do hacking into post. This is good. This is actually a four-step like how you can reach at the point where you can start heading into the postseason schedule. I get about this. Talk basically came from this PG County Event where in past couple of years, many of us like I'm a developer and I know postgres SQL, I'm using it from three, four years and now I want to contribute to
the community but not exactly sure where to start and I had this kind of conversation with a few people and this time I told like let's do some talk around these so that it can beneficial two more people and we get more into the community especially from India. If you do the Google or the look at the YouTube, you'll find a similar to almost every conference has won two of which basically talks about how to do the checking into the post-industrial. But in this truck, I'm not getting much deeper into that. I, I just want to touch the black bears. When someone at the end of this. Someone can go
and start looking at and contributing to her supposed to be secure. Yes, what about me? I do the future development in postgresql as well as enterprisedb. This company we have a large customer base. So the video for night, doing great with the customers to help them and be part of their success stories. This is the content of today's top initial vote to the about the post office and they're like help with physical development cycle. Bust of what kind of release cycle is into the post a schedule, where one can start to contribute, how they can start
voting kind of a feedback process and how that works into the Post-Gazette skill development Community studies and the questions I want you. So if you guys have any questions in between, please feel free to ask, of course, time is a priority. So if it's towed longer, we can always discuss after the talk. I'll be around. Okay, so let's talk like before. Starting one question, like, how many of in audience are there order? And how many of you are a seagull.
Hi, yes, this is a meat sort of audience and this is really about that. I mean when you start a conversation with someone about like how they can contribute to the community, they will miss us. The first question, do we need to be a sequel to answer? Is no, you don't reply to be a sequel to what you can help into the community and they can contribute. So, we'll go to the exactly. You can contribute Tell about the post-process kills, it's a coded engine. What that means. Like you you give them a data, it was
all about the devil and it has a worldwide investment. It's so pretty to use. What really means is like anyone can download music free and then do not need to pay but the maintenance and support but is something which they inside help you take care of it. It has a very steady and well design development process. Yeah, for the enterprise-level customer that they might find like was this development cycle is very slow and sometimes it is. But to get the boot features into the special part. It it requires a good amount of time and a good part about it,
considered opinion quite thrown into it and then try to implement the feature. It's very open for the new ideas. Like if anyone have any kind of idea about the day, it's really get accepted there. At least get listen, the even if it's not get listen to all the communication which basically do in the poster says he has been archived. So in future, one can go there and try to see like we were interested in what kind of things and eventually you might get there.
It's highly probable in this conference. We are hearing light post this ecosystem? What is possible? Because of this is pluggable. Anyone can do any write code in the post-classical around 2 due to communication skill Apples with mint in the very high court quality. So if you open the post this source code, you will find like there are tons of commands into the source code to make any easily understand about the how the things about. If you go to the GitHub and try to see the geek commit
message, you will notice like every commit message has a good amount of information which will make anyone understand like what this government is actively doing. Okay, so funny questions. So I want to post physical development. Cycle school has a 29, Post-Gazette school has a one year lease that's basically and mostly September to September and the process is divided into two phases of the new development of a future beat small or big features. Basically during July, to April, get committed into the
period from April to September. So what exactly that means he's like every major leagues has a kind of a relief manager designed to that release and they make sure about the stability of the product during this phase. So this is basically mostly contained the boxes and any defect which has been found out during This face. What musical instrument in the minor versions of what minor was? It means he's like that if he talked about the current leader of men
happening on the Post-Gazette good looking. So, all the other branches, which is like 11 10 9 6 + 195. It's considered as a minor release. Do any new picture download man release his tax only for the bug fixes. My some of the note to be happy with this because they might want to use the new features into the branch, but due to the design and everything in the Post-Gazette. It's really not feasible to do that. And that is the reason like all the major features and development happens on the master branch. What's
this girl? Has a range of light cycle after every four years? That means he's like 12 released last year. 2019. So it has an end-of-life cyclist 2024 difficult to convince the customers, like they need to operate. But if you think On the Border respiratory, if you need to, if you want to take advantages of new feature which is get booked into the post-gazette's girl, it's really necessary to do the upgrade for development. Like, if you continue to support the old branches like back-patting, the book fixing to the whole
dances easy architecture in the design is in every major religions. Okay. So what's good at school, mailing list anything, or mailing list is one of the primary way to interact with the Post-Gazette School Community. You can play golf on going development, releases of the postal system documentation or anything. Basically, if you want to ask the question raised, the things of what I need to do me to the post office at school mailing list. How many of here are like,
subscribe to the post office in YouTube? And how many of us escaped to the post office? mine is like, if you are starting the to do the development or do that contribute to the community desire to fight list at once, to the subscribe to it. Supposed to say school bugs, basically talks about any bugs you find. You can sleep over there or you can have of you like what the other users are, finding the bus is supposed to be stronger than discussing happens on a general about releasing stress and everything. Are they supposed to get stickers? That's basically
and leaves us and all the development will attack is this person and the other things he gets the most live mailing list in the post-classical. The old school related discussion happens. Like if someone feels like my Discover he's not performing Google. How can I transfer it to this and those kind of questions Discuss in this school, which basically gives you a notification. Every time it happens on the voice message. These are the few resources available which I would recommend to look at. If anyone wants to contribute
into the post office at school Community is a very good deal open guide which is available on Wikipedia and it tells you about everything like from where to download the source to what kind of tool you can use to develop and what kind of performance enhancement or anything. If you're looking, what kind of tools you can use or from where to start in the development perspective is in the flip Channel which is their purpose on this planet. Apart from all these would I find the most useful as like nowadays, there are many forces confessing happening around the world and the most of the
conference to upload. They're holding on to the YouTube channel. So if someone wants to learn about more about the post, please start with that. And anyone who wants to physically do the development or do the contribution to the community dimmest, subscribe to bgs kill hackers. No violence would contribute to talk about and it's really fun to be part of a community. That's really cool. Like, I am not sure, but for me, that was the only motivation to get into the post office as well. And I found
it very good when lightforce Facebook committed, or when my first bug, which has been reported in to the post office Gilbert can meet at that. And I, I can see my name there, so that's a good reason to continue. Do you understand how both places? Good work in the morning, discussing about the 10 mistake of people generally do when my dad from Oracle to PG and he tried clicking it, like buy one suit in the state first posters SQL. Rather than directly looking at like how what kind of option I can get in fourth
grade to be compatible with Oracle. To get up-to-date into the post basic skill in the new development perspective. I'm sure like men you get a few people came to another booth and there have been asking, like, what kind of things we can expect on PG-13, what, what kind of things with Community thinking to do all the horizontal school if you start contributing and keep your eye on mailing list? Opposed to other reasons had become better programmer, and the commercial opportunities we can already see like what how
was this is growing. And you can imagine the things and Commercial Opportunity by looking at this conference and many companies are coming here and I think everyone in everyone boots. There is a take about, we are riding Activate knife questions, maybe because I'm a big nut. So pardon if it's obvious to everyone. My first question is how many actually active developers are there in postgresql community and to have to understand that. So that number is a hundred, then I want to know that hunted.
How many are coming from three or four companies only? That dick I might be difficult to get in the store and Wikipedia page of every contributor and organizes the name is there. A question I had was mentioned about getting over excited about when he made the first contribution. So this was before you did this contribution after he joined to this to the post office as well after 20 TV. Okay. The question is how can we contribute? I mean before, even starting to cause division, the primary goal here should be like, how can I minimize
the time for the commuters? If you looked at my earliest like there are only 29 kilometres in the post-classical community, right? And if we look about the numbers like how many people do the men in the community that they must be in a hundred? So I think of like how can I contribute to the first goal to be like, how can I minimize the time for the computer so that any better or any feature comes to the commission split, it becomes them easy to be committed. Your view
on a page like, is it really helpful? Someone might think that this feature is cool, but your views might be different from that, feel free to share that because that matters when it comes to take a decision about the weather. This page is really useful or not open yet in something which is countable one can give you the only test a disc is part of the page soup. Every feature has a huge kind of a cold and it's not necessary. That only one person get involved into the reviewing. The
patches you can decide to pick the part of a page. Every place has a best guess you can just take off. Like I will just review The Test Kitchen and see whether it works, what has been beaten. So this is a decision that one has to match. You can do contribution was reviewing the documentation part of the bed and I didn't get no, no contribution. It's too small. So any start is really something which is Monday to do when they want to contribute into the community.
So yeah, so next is like stronger to start in my opinion. This is Logan district is something best. I what I learned on bedroom lights begin. So what I'm suggesting that might meet download might not be the only way to contribute there might be other ways but this is one of the way. What is a piece? Any future, or any bug fix which episode of Bosque School community that has been tracked to this comic Fest app? So one can log in here and if you see that is a close close close and open and future. Those are the dummy face which is right now
available to anyone to submit submit submit a new feature. So one can go here and loop on the open. Alchemy face page. When you open that page, it will list you all the pages which has been submitted in this coming first, right? And if you see here, that is a Status of the page water and there's a reviewers and commentators and Swan information here. So one can look around this topics and see like what what are some things, which interests them and another thing which I want to do so yet he's like if you see you on the
first guess as well, that is a multiple open for a single bug fixes, and if you see that are multiple reviewer for the Box 6, so it's not necessary that if there is already reviewed some pet, you cannot be part of that. You cannot do it if you so You just look go to this list and try to see that you can go to bed. These are the categories like that can be a bug fix. That can be a Ford commands related page document to send page see here. The title first was bug fix, but when you scroll down, you'll get other categories. So what need to understand like where the interest is, if someone
is good that letter documentation, that they can go into that category and try to see if they can contribute to review any of the face. I just opened one of the book fixed there because I wanted to, so the information in this bed you can see you can find the original trade of where the oldest person is going on these emails, right? If you click on that, it will take you to the hikers mailing list so that you can see. Hold the discussion happened for this particular faith and the money to understand. Before, starting. If you want me to
go to whole email list all the discussion on this particular feature, another interesting here is the status thing, if you see that is the status of each day, like this patch has been moved from how many comic Fest like, this was submitted on 2019 03 and its 2023 and still, it's not connected. So these are kind of information you can look. Once you click, you're interested page and you can decide whether to be able to jump on this thing or not. Yeah, I'm going to get slight, sorry. Oh yeah, I didn't Define the feature of the
page. So as I don't like first wins to identify the picture, you need to read through all the trade, understand the purpose of the feature, and ask a question. Like he's he's he's a feature of which I'm interested in. You, once you started looking at the email chain, you need to understand like does it at the old Dimension concern, does the detail and the design has been reviewed or discussed on the thread. Those kind of information is something which basically thumbs to the practice. So what kind of experience in looking at the patches for the beginners? I would
suggest to pick some small bags, or maybe to start with the documentation order test, guess patches. So that they get the idea about the process of how to contribute their Okay, so once you have a bitch, what you need to do, you need to clone the sword configure, it just do the apply and complete. That's how you compile the source code. So1 speech is applied. You need to start doing the testing and see whether Paige is doing. Work has been expected. And try to look and test the other part of the page.
Good. Then delete. These are the question. I ask myself. When I start review any page, like does the page work as specified? That doesn't mean this question doesn't mean whether the water has returned to correct things or not, but it might happen that author is writing their O'Donnell liners environment. And I'm doing testing on a Mac OS, so just verifying light. Whether it works as specified. It has some kind of a random experience, the other environments. Apply the page to the source code as
seen on the previous slide. Then. Titan season 3 L for feel free to share your opinion. Like after looking at the page, you realize, like let's say someone has introduced new syntax into the, what's the desk looking at the place you found that there is already a similar, kind of synthetic available in postgresql and do not need to introduce a new things here. You can share your opinion there. That, in my opinion, this feature is something you can get the rod work out for this
features and doesn't find it that exciting. Does the important part to look at the page is like the stupid include the test case if not, you can report into the hackers like this place doesn't have any task. Is now having said that like it. It's not necessary that every page need to have a test case. So need to study like what kind of things you are thinking about, you need to look at is like she's doing something into the letter, configuration parameter, or introducing a new synthetics. I need to make sure that there is a document to sign changes as
part of the bed. So those are kind of a lunch with ask does it follow the SQL standard? Does it follow the community standards does? The BART bass has any performance impact ask once they start reviewing. Are there any patches into the community? Wiki page, which facility, explain the coding standards that are more info about like how. When to start reviewing the page? I want to start submitting application. What kind of things do you need to take it before doing? So you can upload this
supposed to do. Once you decided to review some page. So one thing we need to make sure about is like once you review the best unit to regularly of a better status into the comic Fest app. Like what if you done with the review, you can change your status to the waiting for other. So that, you know, that now it's in his plate and he need to take out of it once. Or third interview are both are in agreement of the dispatches would need to change it to the ready for kamita status of the computer can pick that patch, Lady, Bulldogs of the review process,
and it's necessary to change the status on the first episode. 8, release manager, get an idea like that stuck if not. Then release medicine has to go to the whole email, these to try to understand where this batch is. Kimberly. If you start submitting a page or even the page, you might get an email from the lease manager that you had hoped for the reviewer of doing the review of this place, but you haven't done anything. So, Once you apply your name, to make sure that you continue reviewing the
page until it gets committed or get into the computer split. This, this is a long process review page is. So one of the thing is like, be peasant. That's something I need to keep in mind and it's really hard to do it. Like, Yesterday in the city, I was talking like her features about committed into the post office and see was working on that feature from four years. So it's a huge amount of time. No, they might be a problem in a design like a design, get a chance or get involved involved in the discussion and it might happen that this process
take longer and once there is changes into the core generally takes time because the system and then get change eventually every time Yep write new feature about the expanse review wherever you can, contribute said it become their father lifetime, it's older mailing list has been archived so it will really respect. You get those l. Yes, that is still true. Like you can sell it. I think you have me. So disappointed, look around and see. These are the some of the interesting statistics like, again, whatever.
But I'm trying to explain is like, just to motivate everyone to the review, the patches and contribute to the community, right? So, if you see the last clothes that 20 2001, it has committed 49-page move to the next exit. 144 Like if you see in whole list of specific keep an eye on move to the next comic Fest, does numbers are really big Interstate when someone can commit. That is another reason is like maybe, that doesn't help that bandwidth to commit that or it doesn't get any attention order any reviewer for that patch.
Heights. OH, There are few Ghirardelli, I'm sure many of these has been redirected because of the design change for any reasons but I'm sure that this number is really use and if we start to review or start to contribute, we can see the changes in this number like Peyton List is more than the move to the next comic Fest. Again one of them this number here is 2019 0 7. 2019 038 has committed number 200 Page and move to the next number is 84 Anyone know what's the reason what happened?
Yes, exactly. So, that's where everyone get me to get more attention at the last of the release. And that's all that's the number of Paces, get committed. There is Android auto like you, you get ahold your cycle to to the Future development. Right? And it might happen that you started early, but at the end of the committee first you realize, like now it's time to the end and let's pack movie quickly quickly. This is a few case studies which I just wasted
years old. This was a picture of employment table partitioning has been returned. So if you see the author has one day and but the reviewer and tested by so many people's rights or to get any new features into the community, it's really important that more if you are getting into the features testing and reviewing For example if I'm making some changes in somebody's in some other part of the world is also making some changes at what point you know is the
integration testing done at a computer level so if I'm doing something it should not be breaking his cord at some point. Or what at what point is a single question is like if two people are developing similar kind of feature, All the feature which kind of a ticket the same area into the community. You live bait is based on this particular coming. So like if you look at the Get Low you will see that your current where you are sitting on the master bath so you can order Spotify in your email like my face is based on this
coming. So anyone who wants to try to review the bed that we going to that commits, apply your bed after that. So if you were not returned. Would any New Zoo Revue? I will do is like it will close on the South Korean directly try to apply the page and it will fade Because there are a number of committees which goes on every day and your submitted with my telephone flick in some of the areas that will happen. Only when like I know you are at your page is that the commission has started downloading after you
submitted the page and then go to make it earlier? So you need to adjust your picture cordingley. Put know, it's not if it's officially sent. Everyone has to start the email communication on here cuz like if I want to download song featured, I was right. There it goes. This is something I'm thinking line and this is something I'm going to work on that. Any anyone see any objection? Or doesn't even see anything with concern you. So I'm sure if someone else is also working on that picture day will sell Ecko. I'm also working on similar, kind
of features that photograph. In Disney's. Next case what I wanted to basically Focus one is like if you see the page has been returned by to developers who made the song was written by some other buttons, great line. Even if you review on the bed, you can get a credit line about like documents reviewed by a place that will be there in the credit line. And the next guess I have is like here even though I haven't done anything, I just reported the bug there that then to Daddy's in my name there. So
yeah reporting of bug is also one of the way Phuket, credit name your name into the credit lines. We are from the guys. Sure. I don't have a good number right now, like sorry. it will be difficult to get the numbers like Volcom is you will consider Yeah. is Define if your ratio is greater than 0.5, then if any of this in perspective, but I think maybe eat The Quake was applied, I got it, but I don't have that data right now, that's what I'm saying. Open Sundays are the references. I used to
Buy this talk
Buy this video
With ConferenceCast.tv, you get access to our library of the world's best conference talks.