Carl Cervone

oss-directory: handle contracts from a deterministic deployer

1

There are some contracts (esp in DeFi) that are deployed across multiple chains from a deterministic deployer. The most popular protocol appears to be this one: https://github.com/Arachnid/deterministic-deployment-proxy You can see...

Thorough review of OSO docs to ensure they reference latest data model and API

1

I did a first pass last week to reflect the updated OSSD schema, but it's worth a thorough page-by-page review to make sure everything is up-to-date. Most important is to...

Starter: A power user is an address that: - Has made more than 100 transactions - Has interacted on at least 30 days - Has interacted with at least 10...

Release a V2 of the trusted user model

1

## Basic idea The trusted user model is being built from a variety of Web3 Social & Identity sources. These currently include: - [Farcaster](https://docs.farcaster.xyz/learn/architecture/hubs): an address that is linked to...

**What is it?** We should have an event type that represents a successful interaction between a Safe and another project's contract. This would be identified by looking at events that...

See [here](https://github.com/opensource-observer/oso/blob/main/warehouse/dbt/models/marts/superchain/rf4_impact_metrics_by_project__schema.yml) as a starter We should also have this for all models marked with V1 postfix.

Update Colab notebooks to new models

1

Go through every notebook in the shared drive and update the query logic to the new models and/or take advantage of more abstracted intermediate models.

Web hook to add new contracts deployed by projects already in the registry

1

Lot of people use hardhat deployer or foundry scripts to deploy. It will be cool to build a hook that automatically adds contract address to the repo or creates a...

### Describe the feature you'd like to request We should create a model that tracks artifacts' name changes. We currently do this for git user names but we should do...

**What is it?** We should leverage our trusted user model to create a "Protocol PageRank" across the Superchain. This might require some dbt magic as the calculations will be tedious...