Analysis of Developer Activities on the Near Blockchain

The Near blockchain has a vibrant and growing developer community. As of recent data, Near boasts over 5,200 developers contributing to 12,500 repositories.

On February 29, 2024, Near experienced a significant surge in developer activities, reaching a peak of 10,800 activities in a single day. This spike has catalyzed a sustained increase in developer engagement on the platform.

The trend of increasing daily developer activity and repository creation has continued, with April 19, 2024, marking an all-time high (ATH) with over 5,160 active developers and 12,500 repositories.

The near-sdk-rs repository stands out as the most active in terms of developer contributions, while Fluencelabs leads as the top repository owner by developer activity.

Moreover, Near has recorded over 312,500 developer activities associated with the GitHub endpoint, underscoring the significant integration and reliance on GitHub within the Near developer ecosystem.

These metrics highlight Near's robust and expanding developer community, indicating healthy growth and active participation in the blockchain's development.

The Near blockchain is a highly performant and secure blockchain protocol designed to facilitate the development of decentralized applications (dApps). To better understand the contributions and activities of developers within the Near ecosystem, we have a dataset named near.core.fact_developer_activity that logs various developer activities. This dataset contains crucial information such as the endpoint used, repository details, timestamps, and provider information.

Objective

The primary objective of the following SQL queries is to perform an exploratory data analysis (EDA) on the near.core.fact_developer_activity database. By generating several metrics, we aim to track and analyze developer activities, providing insights into the usage patterns, most active repositories, key contributors, and overall trends over time. These insights are valuable for assessing the health and growth of the developer community within the Near blockchain ecosystem. The specific metrics we intend to analyze include:

• Total Number of Developer Activities: To determine the overall volume of developer contributions.
• Number of Developer Activities by Endpoint: To identify which endpoints are most frequently used by developers.
• Developer Activities Over Time: To observe activity trends and patterns over different time periods.
• Top 10 Repositories by Developer Activity: To highlight the repositories that receive the most attention from developers.
• Top 10 Repository Owners by Developer Activity: To recognize the most active contributors in terms of repository ownership.
• Average Activity per Repository: To calculate the average developer activity per repository, providing a measure of engagement.
• Developer Activities with GitHub Endpoint: To focus specifically on activities related to GitHub integrations.
• Most Active Days: To find out the days with the highest volume of developer activities.

By executing these queries, we can generate a comprehensive overview of developer activities, helping to inform strategies for community engagement, resource allocation, and platform development within the Near blockchain ecosystem.