Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【TiDB 社区第三届专栏征文大赛进入评审阶段啦】看看超丰富周边奖励、返场行李箱、BOSE 耳机、SKG颈椎按摩仪、新款冲锋衣花落谁家！
|
username: Billmay表妹
Column article submission portal: 专栏 - 编辑文章 | TiDB 社区
Looking Back
On March 14, 2022, with the launch of the “Column” feature, we held the First TiDB Community Column Essay Contest, during which 45 participants contributed 103 high-quality articles.
@代晓磊_Mars won the first prize!
@Gin @Jellybean @数据小黑 won the second prize!
@hey-hoho @jiyf @jiaxin @ShawnYan @mydb @banana_jian won the third prize!
@Jellybean @ShawnYan @hey-hoho @h5n1 won the Best Popularity Award!
On March 1, 2023, we launched the Second TiDB Community Column Essay Contest, receiving 58 articles from 29 TiDBers.
@hey-hoho won the first prize!
@Jellybean @caiyfc @sdojjy won the second prize!
@cchouqiang @weixiaobing @asddongmen @Raymond @pepezzzz won the third prize!
@caiyfc @hey-hoho @Jellybean @BraveChen won the Best Popularity Award!
@清风明月 won the Best Diligence Award!
New Journey
From 2019 to the present, we have accumulated 268 community evangelists and published a total of 1165 articles.
In the community, we always see these dedicated TiDB community evangelists,
who often use their personal time after work and on weekends to write the most thoughtful articles for us.
Among them, we also see new faces. We are very grateful because your articles have helped over 30,000 community users
avoid many detours and pitfalls.
What is the value of an article?
It is that the article you painstakingly wrote has helped one friend after another troubleshoot tricky issues and handle many incidents that could have cost them their jobs.
Fortunately, with the continuous improvement of the TiDB product, the stability of the 6.5.x and 7.5.x products has greatly improved.
We also need to thank you for your persistent guardianship of TiDB and growing with TiDB. I will remember every year you accompanied us.
Essay Topics
In principle, any topic published during the event period counts as participating in the essay contest, but we would especially like to see articles on the following topics:
-
Application of New Versions of TiDB (including the application of new features and functionalities): such as trial and application of new versions like v6.5.x, 7.1.x, 7.5.x, 8.x (expected to be launched at the end of March), sharing your user experience and evaluations of the new features brought by the new versions;
-
Industry Practices of TiDB: Sharing TiDB practices in industries such as retail, finance, Internet+, SaaS, overseas, gaming, healthcare, education, etc.;
-
Cost Reduction and Efficiency Improvement Solutions with TiDB: How to use TiDB to help businesses and companies reduce costs and improve efficiency;
-
AI+TiDB: Sharing scenarios and application practices of combining TiDB with AI;
-
Localization Transformation: Sharing practices of using TiDB for localization transformation;
-
Database Migration Practices: Sharing practices and product benefits of migrating from db2, Oracle, MySQL, MongoDB, OceanBase, PostgreSQL, SQLServer, MariaDB to TiDB;
-
Performance Optimization and Tuning Techniques of TiDB: Sharing your experiences of encountering performance issues while using TiDB and how to optimize to improve system performance;
-
Principle Interpretation and Analysis of TiDB: Analyzing and interpreting the principles of various components of TiDB such as TiFlash, TiKV, dm, TiUP, and various features and functionalities;
-
Stability Performance of TiDB: Testing and analyzing the stability performance of TiDB, and providing suggestions for product improvement;
-
Scenario-based Database Architecture Design: Sharing how you adjusted the database architecture while using TiDB and the benefits after the adjustment;
-
My Story with the TiDB Community: What stories do you have worth sharing between you and the TiDB community?
Activity Rewards
Participation Rewards
Publishing articles that meet the essay topics will earn:
1. Each article can earn 100-600 points & experience points
2. Get the exclusive participation badge for the third column essay contest: Pen and Ink Fragrance Badge✨
First Prize (1 winner)
The TiDBer with the highest total score will receive a first prize trophy + honorary certificate + Wenbing Dragon Badge✨ + BOSE noise-canceling headphones + Breo neck and waist massager + TiDB community premium peripheral 8-piece set + 1000 points
1. Bose Noise-Canceling Headphones
2. Breo Neck and Waist Massager
3. TiDB Community Premium Peripheral 8-piece Set
Includes:
- 2024 sports 4-piece gift box (includes gym bag, water bottle, massage gun, resistance band)
- 2024 community spring mountain functional jacket
- TiDB limited edition custom suitcase
- 2024 TiDB community new backpack
- 2024 new fisherman hat
- 2024 new phone/tablet stand
- Fast charging head (can charge a computer)
- Custom mechanical keyboard
4. First Prize Trophy + Honorary Certificate + Honorary Badge + 1000 Points
Second Prize (3 winners)
The TiDBers with the second to fourth highest total scores will receive a second prize trophy + honorary certificate + Wenbing Dragon Badge✨ + TiDB community premium peripheral 8-piece set + 500 points
1. TiDB Community Premium Peripheral 8-piece Set
Includes:
- 2024 sports 4-piece gift box (includes gym bag, water bottle, massage gun, resistance band)
- 2024 community spring mountain functional jacket
- TiDB limited edition custom suitcase
- 2024 TiDB community new backpack
- 2024 new fisherman hat
- 2024 new phone/tablet stand
- Fast charging head (can charge a computer)
- Custom mechanical keyboard
2. Second Prize Trophy + Honorary Badge + 500 Points
Third Prize (5 winners)
The TiDBers with the fifth to ninth highest total scores will receive a third prize trophy + honorary certificate + Wenbing Dragon Badge✨ + TiDB community peripheral 6-piece set + 300 points
1. TiDB Community Peripheral 6-piece Set
Includes:
- 2024 sports 4-piece gift box (includes gym bag, water bottle, massage gun, resistance band)
- 2024 community spring mountain functional jacket
- TiDB limited edition custom suitcase
- 2024 new fisherman hat
- 2024 new socks
- 2024 new phone/tablet stand
2. Third Prize Trophy + Honorary Badge + 300 Points
Special Awards
Most Popular Article Award (1 winner)
This award will be given to the work with the highest number of likes and favorites. The winning TiDBer will receive an honorary certificate + Ti industrial style mechanical keyboard + heated mouse pad + personalized keycaps + efficiency/rest gravity-sensing timer
Most Popular Award (1 winner)
This award will be given to the work with the highest number of votes from community members (favorite article Top 1). The winning TiDBer will receive an honorary certificate + Ti red camping gear five-piece set + SKG neck massager
Best Writer Award (1 winner)
This award will be given to the author with the most articles. The winning TiDBer will receive an honorary certificate + Ti industrial style mechanical keyboard + TiDB cassette mobile power bank
Best 7.5.x Version Practice Award (1 winner)
This award will be given to the best article on the TiDB 7.5.x version practice theme (voted by the jury). The winning TiDBer will receive an honorary certificate + TiDB community custom (Xiaomi) eye-protection monitor lamp + 2024 new Ti fisherman hat (2 pieces)
Best AI+TiDB Innovation Practice Award (1 winner)
This award will be given to the best article on the AI + TiDB theme (voted by the jury). The winning TiDBer will receive an honorary certificate + 2024 sports 4-piece gift box (includes gym bag, water bottle, massage gun, resistance band)
Review Process
The third column essay contest will be judged by the column contest jury, who will score the submitted articles (based on the depth and quality of the article, originality, completeness of content and structure, logic, fluency of expression, etc.; bonus points for reference value, practicality, and innovation, with a total score of 1-10 points, the highest being 10 points and the lowest being 1 point), and the winners of the first, second, and third prizes will be determined by the total ranking! (Multiple articles winning multiple awards will only be awarded the highest prize)
In addition, the jury will vote to determine the winners of the Best 7.5.x Version Practice Award (1 winner) and Best AI+TiDB Innovation Practice Award (1 winner).
The column contest jury will be composed of the evangelist committee members, including @xuexiaogang @代晓磊_Mars @xfworld @CuteRay @Jiawei @田帅萌7 @caiyfc @ShawnYan. Additionally, we will recruit 3 community members to participate in our article review (interested teachers, please contact TiDB Robot on WeChat: tidbai, reviewers are required to have published at least three articles in the community).
Essay Requirements
-
The submitted work must be original and not published on other media.
-
The content of the article should be closely related to the theme, with a certain depth and breadth, providing valuable information and insights to readers.
-
The article should be fluent in language, logically clear, and well-structured, with no less than 800 words.
-
The article can be in the form of text and images to enhance readability and attractiveness.
Submission Portal
Click Publish Article
Comment to Win (1 person will be drawn to receive the 2024 community spring mountain functional jacket)
Leave a comment with the article topic you most want to see, and one person will be drawn to receive the 2024 community spring mountain functional jacket.
Submission Time
March 1, 2024 - May 30, 2024
Activity Timeline
- March 1: Essay contest begins
- March 1 - May 30: Essay contest submission period
- May 31 - June 13: Article review period
- June 17: Announcement of essay contest results
- June 19: Prize distribution
Writing Guide
Here is a Guide to Publishing Technical Articles in Columns & Rewards for those writing a community column for the first time. The guide includes:
1. The value of technical articles
2. How to write a high-quality technical article?
3. How to choose the theme of a technical article?
4. How to start writing a “high-quality” technical article after choosing a topic?
5. Content that is not popular and will not be approved
6. Technical article reward rules
7. Standards for high-quality articles
Scoring Dimensions
- Structural Completeness: Complete content structure, text and images
- Thematic Typicality: Content depth, content quality, and reference value and impact on other TiDBers
- Content: No technical errors, smooth language, clear logic, fluent writing
- Bonus Points: Reference value, practicality, innovation
Peripheral Preview
2024 Sports 4-piece Gift Box (includes gym bag, water bottle, massage gun, resistance band)
TiDB Limited Edition Custom Suitcase
TiDB Custom Mechanical Keyboard
TiDB Cassette Mobile Power Bank
Fast Charging Head (can charge a computer)
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: