Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【奖项公布】TiDB 社区专栏第二届征文大赛获奖名单出炉！来看下是谁最后带走的 Bose 降噪耳机！
|
username: Billmay表妹
The Second TiDB Community Column Essay Contest Has Ended
After 3 months of literary collisions from different community members and multiple rounds of selection by the evangelist review team, the TOP 3 outstanding articles were finally chosen. 
Each column article conveyed the accumulated knowledge and experience of the authors. Thanks to all the TiDBers who participated in this column essay contest. Your dedication and contributions have brought endless vitality to our community, allowing the story of TiDB to continue.
Contest Data
From March 1, 2023, to May 31, 2023. We received a total of 58 articles from 29 TiDBers.
Thanks to all the TiDBers for your contributions. Your articles have filled the community with vibrant energy.
Review Process
The review process started on June 5 and lasted until June 20. Thanks to all the teachers in the second TiDB essay contest review team for their hard work. @caiyfc @xfworld @代晓磊_Mars @xuexiaogang @数据小黑 @jiawei @包老师呀 @CuteRay
Despite their busy work and life schedules, they still seriously participated in the review and discussion of the essay contest, striving to select the winners in the fairest way. You are an indispensable part of the essay contest.
Thank You Gifts for the Judges:
Initial Screening Review Discussion:
The judges proposed improvements to ensure fairness by removing the highest and lowest scores, and the final score was the total score. They also discussed publishing the data overview after each batch of article reviews to ensure a unified scoring standard among all judges.
A Little Episode:
@xuexiaogang insisted on completing the review work while accompanying his family in the ICU. We originally hoped to reduce the burden on the teacher by inviting additional judges, but the teacher still squeezed out time to complete the review work amidst his busy schedule (very touching). Life is not easy, but we can always see the figures supporting each other forward. 
Final Review Discussion:
The judges re-evaluated and selected the TOP 10 articles, and the final score was based on the initial screening total score + final review total score. After final confirmation, our TOP 3 were born. (The long review process, thanks again to the teachers for taking the time to seriously participate in the review)
The decision-making process was very difficult because the scores were too close! After combining the total scores from the first round, the specific list is as follows:
The serious attitude of each judge towards the articles amazed me and made me realize that even the smallest details can make a difference. The reason why the TiDB community has become such an active and loving community today is because everyone treats the community and everyone in it with meticulous care!
Winners List
The exciting moment has arrived! Let’s reveal the TOP 3 of the second column essay contest.
First Prize
| Author | Article | Link | Views | Favorites | Likes |
|---|---|---|---|---|---|
| hey-hoho | TiDB SQL Optimization Case: Avoiding TiFlash Backfire | 专栏 - TiDB SQL调优案例之避免TiFlash帮倒忙 | TiDB 社区 | 370 | 7 | 10 |
Congratulations: @hey-hoho for winning the first prize! 
Second Prize
| Author | Article | Link | Views | Favorites | Likes |
|---|---|---|---|---|---|
| Jellybean | Sliding Window Real-time Cumulative Indicator Algorithm Based on TiDB+Flink | 专栏 - 基于TiDB+Flink实现的滑动窗口实时累计指标算法 | TiDB 社区 | 586 | 12 | 9 |
| caiyfc | Step-by-Step Guide to Becoming a TiDB Contributor | 专栏 - 手把手教你成为 TiDB 的 Contributor | TiDB 社区 | 261 | 11 | 11 |
| sdojjy | TiCDC Source Code Interpretation (6) - Introduction to TiCDC Puller Module | 专栏 - TiCDC 源码解读（6）- TiCDC Puller 模块介绍 | TiDB 社区 | 84 | 2 | 0 |
Congratulations: @Jellybean @caiyfc @sdojjy for winning the second prize!
Third Prize
| Author | Article | Link | Views | Favorites | Likes |
|---|---|---|---|---|---|
| cchouqiang | TiDB Cluster Database Disaster Recovery Manual | 专栏 - TiDB集群数据库灾难恢复手册 | TiDB 社区 | 48 | 9 | 8 |
| weixiaobing | Cluster 3 Replicas Lost 2 Replicas - Unsafe Recover | 专栏 - 集群3副本丢失2副本-unsafe-recover | TiDB 社区 | 161 | 2 | 2 |
| asddongmen | TiCDC Source Code Interpretation (5) - TiCDC DDL Event Handling Logic and Filter Implementation Introduction | 专栏 - TiCDC 源码解读（5）-- TiCDC DDL 事件处理逻辑 与 Filter 实现介绍 | TiDB 社区 | 57 | 1 | 0 |
| Hacker_loCdZ5zu | Detailed Explanation of tiup cluster display Execution Process Code | 专栏 - tiup cluster display 执行流程代码详解 | TiDB 社区 | 116 | 1 | 2 |
| pepezzzz | Software and Hardware Load Balancing IP Address Pass-through | 专栏 - 软硬件负载均衡 IP 地址透传 | TiDB 社区 | 141 | 1 | 0 |
Congratulations: @cchouqiang @weixiaobing @asddongmen @Raymond @pepezzzz for winning the third prize!
Most Popular Award & Diligence Award:
Most Popular Award:
The Most Popular Award = the number of likes on the article. The top 3 articles with the highest number of likes win the Most Popular Award. This award can be won simultaneously with the first to third prizes.
| Community Nickname | Title | Link | Likes |
|---|---|---|---|
| caiyfc | Step-by-Step Guide to Becoming a TiDB Contributor | 专栏 - 手把手教你成为 TiDB 的 Contributor | TiDB 社区 | 11 |
| hey-hoho | TiDB SQL Optimization Case: Avoiding TiFlash Backfire | 专栏 - TiDB SQL调优案例之避免TiFlash帮倒忙 | TiDB 社区 | 10 |
| Jellybean | Sliding Window Real-time Cumulative Indicator Algorithm Based on TiDB+Flink | 专栏 - 基于TiDB+Flink实现的滑动窗口实时累计指标算法 | TiDB 社区 | 9 |
| BraveChen | Quick Forced Rollback Plan When TIDB Upgrade Fails | 专栏 - TIDB升级发生故障时，快速强行回退方案 | TiDB 社区 | 9 |
Congratulations: @caiyfc @hey-hoho @Jellybean @BraveChen
“Diligence is the Path to Success” Diligence Award
| Community Nickname | Number of Articles Published |
|---|---|
| 清风明月 | 10 |
Congratulations: @清风明月
Winning the first to third prizes entitles you to the “Writing Like a Pro” community badge and the TiDB custom liquid sand painting trophy
Thanks
Thanks again to all the TiDBers for participating. You used words to convey every step and heart, and the knowledge and practice you learned to all the partners. In the future, let’s continue to let words take root in the community and pass on knowledge to more partners.
|
username: