The Graph Hosted service sunset

[daviddavo]

The Graph will sunset is hosted service on 12 of June, 2024. We need to either freeze the data collected from the dao-scripts, or migrate to the new Decentralized service.

• https://thegraph.academy/developers/sunsetting-the-hosted-service/

This new service is not entirely free, but comes with 100.000 free queries per month.

We would have to do the following tasks

• [x] #10
• [ ] Analyze the logs to count the number of queries done each day, and in the case we need to collect the data all over again to be able to estimate if we would need anything besides the free tier
• [x] Create a wallet
  • Using Coinbase: ddavo.cb.id. Private key and recovery phrase were securely stored by David Davó
• [x] Migrate all the graphs out of the hosted service
  • [x] _blocks/mainnet (official)
  • [x] daostack/mainnet (ours)
  • [x] daohaus/mainnet
  • [x] aragon/mainnet (ours, had to make substantial modifications and redeploy, and pay about .2 cents in gas)
  • [x] aragon_tokens/mainnet (ours)
  • [x] aragon_voting/mainnet (ours)
  • [x] aragon_finance/mainnet (ours)
  • [x] _blocks/xdai
  • [x] daostack/xdai (ours)
  • [x] daohaus/xdai
  • [x] _blocks/polygon (ours)
  • [x] daohaus/polygon
  • [x] _blocks/arbitrum (ours)
  • [x] daohaus/arbitrum
• [x] Make this application use the new graphs
  • [x] _blocks/mainnet
  • [x] daostack/mainnet
  • [x] daohaus/mainnet
  • [x] aragon/mainnet
  • [x] aragon_tokens/mainnet
  • [x] aragon_voting/mainnet
  • [x] aragon_finance/mainnet
  • [x] _blocks/xdai
  • [x] daostack/xdai
  • [x] daohaus/xdai
  • [x] _blocks/polygon
  • [x] daohaus/polygon
  • [x] _blocks/arbitrum
  • [x] daohaus/arbitrum

[daviddavo]

Theres no need to hurry with #10 because the interface shows the number of queries made to our subgraphs and is WAY less than 100.000

[daviddavo]

After trying to re-deploy aragon subgraphs in xdai, they raise a lot of errors and failures. The xdai endpoints are already disabled and haven't been shown in dao-analyzer since a couple years ago, so I think it's fine if I finally remove them from the code.

[daviddavo]

Some of the queries to the aragon subgraph fail.

My theory is that some of the queries go to the indexer with the v1.0.0 version, and some of them go to the old version. We will have to wait until the old version is offline, which should take just a few hours. Then, I'll merge the application.