Developer Data

Schema: Developers

This schema contains developer activity data (weekly commits and weekly active developers) for the entire crypto ecosystem. It allows the user to construct everything on our Developer Activity Dashboard here and more.

Artemis Dashboard

Developer Activity

Details

• Tracking:

  • 167,956 repos

  • 244,191 developers

  • 5,872 ecosystems

  • 3,848 sub-ecosystems

• Refreshed weekly

• Protocols to Github repo mapping powered by Electric Capital’s open source crypto-ecosystems repo. Continually maintained by Electric Capital and open source community

• Only open-source (i.e. public) Github repositories are counted

Ecosystem vs Sub-ecosystem

Ethereum is an example ecosystem and subecosystems are projects build on top of other projects. For example, Aave or Uniswap would be a subecosystem of Ethereum. Due to the composable nature of Web3 projects, subecosystems themselves can have subecosystems. E.g., Aavegotchi is build on top of Aave, so Aavegotchi is a subecosystem of Aave.

Sample Queries

// Total number of commits for all repos over time by week
SELECT *
FROM   weekly_commits_global
ORDER  BY date DESC 

// Total number of weekly active developers for all repos over time
SELECT *
FROM   weekly_devs_global
ORDER  BY date DESC 

// Weekly active devs of Ethereum
-- Get ecosystem_id of Ethereum
SELECT *
FROM   ecosystems
WHERE  ecosystem_name = 'Ethereum' 

-- Lookup dev activty for Ethereum
SELECT *
FROM   weekly_devs_core_ecosystem
WHERE  ecosystem_id = 1266 --1266 is Ethereum's ecosystem_id
ORDER  BY date DESC