With the first quarter of 2024 out of the way, we can take a look at the contribution statistics for the last three months. For the Foundation, this has been a very busy quarter, we have had a few big events to prepare for and attend. As well as two very large projects we are working on (Catalogs and vector indexing). This has meant that it has been difficult for us to keep up with all the wonderful contributions.
That being said, over the coming quarter we will try to rectify this and have some plans to make things better in future.
2024 Contributions
Let’s take a look at the contributions that made it so far this year.
| Organisation | Contributors | Commits |
|---|---|---|
| MariaDB Plc. | 23 | 425 |
| MariaDB Foundation | 6 | 37 |
| Independent | 8 | 23 |
| Codership | 3 | 19 |
| Amazon | 6 | 10 |
| Alibaba | 1 | 2 |
| OpenBSD | 1 | 2 |
| University of Sydney | 1 | 1 |
| IBM | 1 | 1 |
We can almost do a like-for-like comparison with Q1 2023, the first 2023 snapshot was mid-March, so is missing about 2 weeks of data, but this should be good enough to get a rough idea.
| Organisation | Contributors Q1 2023 | Contributors Q1 2024 | Commits Q1 2023 | Commits Q1 2024 |
|---|---|---|---|---|
| MariaDB Plc. | 23 | 23 | 342 | 425 |
| MariaDB Foundation | 7 | 6 | 80 | 37 |
| Other | 21 | 22 | 38 | 60 |
| TOTAL | 51 | 51 | 460 | 522 |
We are about on-par on both contributors and commits, particularly if you adjust for the differences in dates for the snapshots.
Pull Requests
Next up, let’s take a look at the state of pull requests. The columns are:
- New PRs: The number of PRs that have been opened that week.
- Draft PRs: Of the newly opened PRs that week, how many are currently drafts.
- Closed PRs: The number of PRs that have been closed that week (not merged).
- Merged PRs: The number of PRs that have been merged that week.
- Total PRs: The total number of PRs we have had up to the end of that week.
- Still Open PRs: The total number of PRs still open (including draft) at the end of that week.
- Days to First Response: The average number of days to first meaningful response of PRs for PRs that have been responded, for the PRs opened that week.
- New PRs Responded: The total number of PRs that have had a meaningful response that have been opened that week.
- PRs Self Merge No Review: The number of PRs opened that week which have been merged by the author with no review from anyone else in the MariaDB team.
- PRs Self Closed No Review: The number of PRs opened that week which have had no meaningful response and have been closed by the author.
| Week Ending | New PRs | Draft PRs | Closed PRs | Merged PRs | Total PRs | Still Open PRs |
|---|---|---|---|---|---|---|
| 2023-12-31 | 8 | 1 | 0 | 0 | 2962 | 199 |
| 2024-01-07 | 10 | 0 | 1 | 3 | 2972 | 205 |
| 2024-01-14 | 20 | 0 | 3 | 9 | 2992 | 213 |
| 2024-01-21 | 10 | 0 | 0 | 13 | 3002 | 210 |
| 2024-01-28 | 14 | 0 | 5 | 10 | 3016 | 209 |
| 2024-02-04 | 15 | 0 | 10 | 7 | 3031 | 207 |
| 2024-02-11 | 14 | 0 | 5 | 12 | 3045 | 204 |
| 2024-02-18 | 16 | 1 | 8 | 17 | 3061 | 195 |
| 2024-02-25 | 10 | 2 | 1 | 9 | 3071 | 195 |
| 2024-03-03 | 14 | 2 | 3 | 7 | 3085 | 199 |
| 2024-03-10 | 24 | 1 | 4 | 4 | 3109 | 215 |
| 2024-03-17 | 11 | 1 | 6 | 5 | 3120 | 215 |
| 2024-03-24 | 19 | 1 | 3 | 6 | 3139 | 225 |
| 2024-03-31 | 15 | 0 | 10 | 8 | 3154 | 222 |
| Week Ending | Days to First Response | New PRs Responded | New PRs Not Responded | PRs Self Merged No Review | PRs Self Closed No Review |
|---|---|---|---|---|---|
| 2023-12-31 | 21.3 | 6 | 1 | 0 | 0 |
| 2024-01-07 | 10.6 | 10 | 0 | 0 | 0 |
| 2024-01-14 | 8 | 18 | 0 | 1 | 1 |
| 2024-01-21 | 4 | 4 | 5 | 1 | 0 |
| 2024-01-28 | 2.9 | 10 | 2 | 2 | 0 |
| 2024-02-04 | 1.4 | 14 | 1 | 0 | 0 |
| 2024-02-11 | 6.2 | 11 | 2 | 1 | 0 |
| 2024-02-18 | 16.2 | 13 | 1 | 1 | 0 |
| 2024-02-25 | 8.8 | 5 | 1 | 2 | 0 |
| 2024-03-03 | 3.7 | 10 | 2 | 0 | 0 |
| 2024-03-10 | 7.6 | 17 | 5 | 0 | 1 |
| 2024-03-17 | 0.3 | 7 | 1 | 1 | 1 |
| 2024-03-24 | 2.2 | 15 | 1 | 1 | 1 |
| 2024-03-31 | 1.6 | 8 | 4 | 2 | 1 |
The key takeaway from these stats is that the pull request counts are growing. We are putting measures in place to help reduce these, but this will take time to happen.
Next Time
If there are any additions you would like to see, please let us know. Otherwise, I’ll be back in April with even more metrics!
Featured image: Binary code by Christiaan Colen used under a CC-by-SA 2.0 license.