Ask or search…
K

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