[Ended] TiDB Community's Second Essay Contest: Take Home All New Community Swag at Once, Plus Bose Noise-Cancelling Headphones and Breo Massagers Await You!

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【已结束】TiDB 社区第二届征文大赛,一次性带走社区全部新周边,还有bose 降噪耳机、倍轻松按摩仪等你拿!

| username: Billmay表妹

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

:one: 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



:two: 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



:three: 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

下笔如有神

:four: “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.

202182-141445

:five: 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:

  1. Register a TiDB Community Account

  2. 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!

  1. The article content needs to be in-depth and of high quality, and the theme must be related to TiDB.

  2. The article must be at least 800 words, with images and text reducing the word limit appropriately.

  3. The article must be original, first published, and not plagiarized.

  4. The review criteria include content and structure completeness, logic, and fluency.

  5. Bonus points for referential, practical, and innovative content.

  6. 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:

  1. Structure Completeness: Complete content structure, images, and text

  2. Theme Typicality: In-depth content, quality, and value to other TiDBers

  3. Content: No technical errors, smooth language, clear logic, fluent writing

  4. 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

  1. March 1: Essay contest begins

  2. March 1 - May 31: Essay contest article submission period

  3. June 1 - June 7: First round article screening

  4. June 7 - June 15: Final judges’ review of articles

  5. June 16: Essay contest results announced

  6. 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!

| username: Kongdom | Original post link

1677719219978

| username: Hi70KG | Original post link

: dotted_line_face: Just go for it

| username: waeng | Original post link

Write, write, write.

| username: tidb菜鸟一只 | Original post link

Writing articles is really not my thing, but reviewing them is fine.

| username: Jellybean | Original post link

The annual competition event is here again, let’s go~

| username: xiaour | Original post link

Go for it, guys, stop competing, let me handle it.

| username: 清风明月 | Original post link

Just go for it.

| username: weixiaobing | Original post link

Go go go

| username: BraveChen | Original post link

Go go go

| username: dcswinner | Original post link

Write a few articles that can win first prize?

| username: TiDB社区小助手 | Original post link

The first prize is determined by scoring. Teachers can participate in the essay competition review by writing one article. However, writing three articles allows participation in the community MVA review. For more information about MVA: 【TiDB Community Honors】How to Become an MVA & MOA?

| username: TiDBer_刚 | Original post link

Still learning, keep it up!

| username: gary | Original post link

Go go go

| username: 清风明月 | Original post link

Charge, charge, charge

| username: TIDB_yj | Original post link

Go go go