趋势榜单需求

[Jiannan-dev]

Description

1、由于已经使用了页面爬取了star，contributor数据，考虑继续增加对fork的爬取

Validations

• Check that there isn't already an issue that request the same feature to avoid creating a duplicate.

[flyfishzy]

我们的数据可以和这个榜单对比验证 https://ossbenchmark.com/repositories

[flyfishzy]

参考这篇文章，考虑引入年增长率AGR的指标。https://medium.com/runacapital/open-source-growth-benchmarks-and-the-20-fastest-growing-oss-startups-d3556a669fe6

[Jiannan-dev]

@Chieffo2021
总量前500.xlsx
增量前500.xlsx

[Jiannan-dev]

参考：
https://github-insights-pro.toolsnav.top/
https://github-persona.pages.dev/

[Jiannan-dev]

年度总量排名

SELECT `date` FROM `trend_history` AS `TrendHistory` WHERE `TrendHistory`.`date_type` = 1 AND `TrendHistory`.`data_type` = 1 ORDER BY `TrendHistory`.`date` DESC LIMIT 0, 1;
Executing (default): select * from (
          select project_id as projectId,
        increased_value as increasedValue,
        total_value as totalValue,
        row_number() over (
          order by total_value desc, increased_value desc) as `rank`
        from trend_history
        where 
          date = '2025-01-01'
          and data_type = 1
          and date_type = 1
          
          
           and  total_value  is not null
    and  total_value  > 0
          order by `rank`
           limit 99 offset 0 ) tmp
          where `rank` <= 500

年度增长排名

SELECT `date` FROM `trend_history` AS `TrendHistory` WHERE `TrendHistory`.`date_type` = 1 AND `TrendHistory`.`data_type` = 1 ORDER BY `TrendHistory`.`date` DESC LIMIT 0, 1;
Executing (default): select * from (
          select project_id as projectId,
        increased_value as increasedValue,
        total_value as totalValue,
        row_number() over (
          order by increased_value desc, total_value desc) as `rank`
        from trend_history
        where 
          date = '2025-01-01'
          and data_type = 1
          and date_type = 1
          
          
           and  increased_value  is not null
    and  increased_value  > 0
          order by `rank`
           limit 99 offset 0 ) tmp
          where `rank` <= 500