Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【已结束】TiDB 社区第二届征文大赛,一次性带走社区全部新周边,还有bose 降噪耳机、倍轻松按摩仪等你拿!
Looking Back
Last year, from March 14, 2022, to May 31, 2022, we held this event.
During the event, 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!
Thanks also to the TiDB Community Column First Essay Contest Review Panel @ShawnYan @数据小黑 @h5n1 @jiawei @caiyfc @HHHHHHULK @Cuteray @ealam_小羽 @代晓磊_Mars @xuexiaogang for their strong support in the review work.
Besides gaining technical articles, last year’s column contest also brought us 【My Story with TiDB】, which gathered stories from 34 community members and TiDB.
This year’s second TiDB Community Essay Contest is here with new peripherals ready! Let’s take a look at the key information for this essay contest.
What is the TiDB Column?
TiDB Community Column is a platform for sharing and learning technical articles established by developers, users, contributors, and partners in the TiDB ecosystem. Here, you can see firsthand practical experiences from the community: troubleshooting guides, best practices, evaluations, principle interpretations, etc., providing you with the most comprehensive TiDB practical technical articles.
New Hope
The birth of the essay contest is because we believe that besides face-to-face communication, words can also touch people’s hearts.
In the first essay contest in 2022, 45 TiDBers contributed 103 high-quality articles to the community. This showed us the power of words in the community.
These articles have built the most solid foundation for the Ti planet, like tree roots nourishing the soil, passing knowledge to more partners.
As guardians of the Ti planet, we have also spared no effort in the past year to spread the achievements of TiDBers to a broader knowledge field. We have collaborated with the community, social media, and social platforms to make TiDBers’ articles deeply rooted in people’s hearts.
To better convey knowledge, we have tried to combine articles with various forms: community push, weekly subscription emails, selected article posters, community monthly, to let more people feel the power of words.
Now, the second essay contest invites all TiDBers to use words to record your steps and hearts in the community and to convey the knowledge you have learned.
Event Rewards
Participation Rewards
Publish an article that meets the essay theme to receive:
-
Each article can earn 100-600 points & experience points, and articles selected for the monthly magazine can earn an additional 300 points.
- Publishing an article can earn 100-900 points
-
Receive the exclusive participation badge for the second essay contest: Book Mountain Badge
Awards
First Prize (1 winner)
First Prize Trophy + Honor Certificate + 【TiDB Community Limited Edition Bose In-Ear Headphones + Full Set of New Peripherals】 Eight-Piece Set
The ultimate eight-piece set, get all the new peripherals at once! TiDB Community Edition Bose In-Ear Headphones + 67W Fast Charging Plug, TiDB New Stickers, Ultra-Thin Phone Stand, White Travel Cup, Custom Timer, All in TiDB Keycap, TiDB Smart Leather Mouse Pad
Second Prize (3 winners)
Second Prize Trophy + 【Easy Back Set】: Easy Back Waist Pillow Massager + Crossbody Bag + 2023 Limited Edition Metal Phone Stand + TiDB Stickers + TiDB New Keycap
Third Prize (5 winners)
Third Prize Trophy + TiDB Crossbody Bag + Mouse Pad + TiDB New Keycap + Fast Charging Plug
Winners of the First to Third Prizes will receive the “Inspired Writing” Community Badge
“Diligence is the Path to Success” Diligence Award
Limited Edition TiDB Community Suitcase (random color)
The participant with the most submissions during the event period, and each submission meets the requirements. In case of a tie, the winner will be determined by popularity = number of favorites **20 + number of likes **10.
Best Popularity Award (3 winners):
TiDB Crossbody Bag + TiDB New Keycap + Power Bank
Enhance Personal Brand & Influence
-
Build personal influence
- Feature on the PingCAP official account headline to deepen personal influence
-
TiDB Community guidance on technical article writing
-
More platforms and opportunities to communicate with evangelists
-
Outstanding content contributors have the chance to participate in TiDB Community Meetups for live sharing
-
Quality content can be promoted through the “TiDB Community” media matrix
How to Participate:
-
Publish a technical article in the column here
Essay Reference Themes:
New Version Practice
Practice based on versions 5.x/6.x, write practice articles, evaluate new versions, upgrade practices, feature interpretations, installation and deployment, migration, backup & recovery, selection comparisons, etc.
Product Architecture & Principles, Source Code Interpretation
Database architecture design, principles
Fault Case Analysis
In-depth analysis, troubleshooting, interpretation, repair, and summary of any fault.
Operations Guide SOP (Operations Manual), optimize SOP for new versions (5.x 6.x) on any of the following themes
Application Development Practices
Using programming languages such as Java, Python, PHP, etc., to connect to TiDB with ORM or driver
Essay Contest Article Requirements:
If you are interested in and have researched TiDB-related products, or have unique stories and experiences related to TiDB, you are welcome to participate!
-
The article content needs to be in-depth and of high quality, and the theme must be related to TiDB.
-
The article must be at least 800 words, with images and text reducing the word limit appropriately.
-
The article must be original, first published, and not plagiarized.
-
The review criteria include content and structure completeness, logic, and fluency.
-
Bonus points for referential, practical, and innovative content.
-
Submission period: March 1, 2023 - May 31, 2023
(ps: Personal memos, records, and notes do not meet the submission requirements.)
Selection Rules:
First to Third Prizes
First Round Selection:
During the essay contest period, the top 50 most popular technical articles in the column will enter the second round of selection!
Popularity = number of favorites **20 + number of likes **10
Second Round Selection:
Judges’ scoring (scoring will be divided into 4 dimensions, each dimension 1-10 points, highest 10 points, lowest 1 point)
Judges, evangelists, and TiDB technical experts will score the articles, and the total score will determine the winners of the first to third prizes.
Multiple articles can win multiple awards, but only the highest award will be given (one person can only win one award, but multiple articles can earn more points).
Scoring Dimensions:
-
Structure Completeness: Complete content structure, images, and text
-
Theme Typicality: In-depth content, quality, and value to other TiDBers
-
Content: No technical errors, smooth language, clear logic, fluent writing
-
Bonus Points: Referential, practical, innovative
Pre-Contest Guide:
Here is a Technical Article Publishing Guide & 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 a technical article theme?
4. How to start writing a “high-quality” technical article after choosing a theme?
5. Content that is not popular and will not be approved
6. Technical article reward rules
7. Quality article standards
Event Timeline
-
March 1: Essay contest begins
-
March 1 - May 31: Essay contest article submission period
-
June 1 - June 7: First round article screening
-
June 7 - June 15: Final judges’ review of articles
-
June 16: Essay contest results announced
-
June 19: Prizes distributed
Prize Details
Bose Noise-Canceling Headphones
Breo Easy Back Massager Pillow
67W Super Fast Charging Plug (for laptops and phones)
TiDB Efficiency Timer & Rest Reminder
TiDB Large Smart Leather Mouse Pad (Heatable)
TiDB Ultra-Thin Metal Phone Stand
Come and sign up to participate!